Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: ORA-22924 reading LOBs / DBMS_REDEFINITON-- any
performance   suggestions ?

Hemant K Chitale

2006-06-01

Replies:


Yes, with parallel_max_servers, I have tried the START_REDEF with PARALLEL
4 on the
source and target tables. Doesn't help enough. I still get
ORA-1555s/22924s in less than 7 minutes
when I expect the copy to take 1.5 to 2 hours.

Hemant
At 04:09 AM Thursday, GovindanK wrote:

>http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tables.htm#19772
>Look at point 3.
>
>HTH
>GovindanK


Hemant K Chitale
http://web.singnet.com.sg/~hkchital


--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.