Rodrigo,
You can use exp/imp with where clause using the parameter QUERY

Regis


-----Original Message-----
From: Rodrigo Andres Benzaquen [mailto:[Email Address Removed] Thursday, May 30, 2002 8:28 PM
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
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.
**********************************************************************

Oracle LazyDBA home page