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

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 01 Jun 2006 21:19:02 +0800
Message-Id: <6.2.1.2.0.20060601211757.01fe1470@pop.singnet.com.sg>

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

Received on Thu Jun 01 2006 - 08:19:02 CDT