How to copy 110GB table with BLOB from one schema to another on ORACLE

Question

I have a table containing 110GB in a BLOB in one schema, and I want to copy it to another schema in another table.

I want to copy the column of the source table, so I use the UPDATE statement, but it takes 2.5 hours to copy 3 GB.

Is there a faster way to do this?

Update:

The code I'm using is very simple:

update schema1.A a set blobA = (select blobB from schema2.B b where b.IDB = a.IDA);

ida and idb are indexes.

Answer 1

Check to see if there are indexes in the destination table causing a performance problem, if so, temporarily disable them, then recreate them after copying data from one column in the source table to a column in the destination table.

Answer 2

Oracle 10 11, ADDM, , . , - .

? 110 ? ?

Answer 3

, . , , , , .

SQL, 10% , . , 10%. , , .

Also, as zendar noted, check the IO drive. If it has a high queue length, you can limit the speed of the drives.