Rodrigo,

According to the copy command, you need to explicitly define the rows you
want in your destination table, if you are using Insert option of the copy
command. Also you could increase arraysize from 5000 records to a more
higher value, though now at a time 10000 records get committed.

Please let me know the progress.

Regards
Ganesh



-----Original Message-----
From: Rodrigo Andres Benzaquen [mailto:[Email Address Removed] Thursday, May 30, 2002 20:28
To: LazyDBA.com Discussion
Subject: How to copy a table with LONG columns


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page