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


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


Other related posts: