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

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: "GovindanK" <gkatteri@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 01 Jun 2006 21:19:02 +0800

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.

At 04:09 AM Thursday, GovindanK wrote:
Look at point 3.


Hemant K Chitale


Other related posts: