I presume you long is greater than 64k? Otherwise copy can be used on long under 64K. - david >> I've got a table in an Oracle7.3 database (that I'm finally getting >> to upgrade and I'm trying to figure out how to get the data from >> the old DB over to the new DB on the new server. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------