Hi gurus,

We have a 11 gb table with a "LONG" column. We need to copy the last 6
months of the table (aprox 6gb).

We tried :

set arraysize 5000;
set copycommit 2;
set long 40000;

copy from user/[Email Address Removed] to user/[Email Address Removed] insert item_descriptions_new
using select /*+ parallel (d,8) */ d.* from oraprod.items i,
orange.item_descriptions d where i.site_id=d.site_id and
i.item_id=d.item_id;
exit

But is not very fast.

Do you know another way to do it more efficiently ?

Thanks in Advance
Rodrigo



Oracle LazyDBA home page