How to replace the "Copy from" command?

From: nionio_usa <antonio.botelho_at_arc-intl.com>
Date: Wed, 23 Jan 2008 05:30:39 -0800 (PST)
Message-ID: <eab591b6-011d-4e2e-961a-19e7479c2a89@q77g2000hsh.googlegroups.com>


Hi All,
Actually using 8i and 9i version of Oracle, we are migrating to the 10g version.
We used to use the "copy from" syntax to copy data from DB1 to DB2 via DBLINK. Looks like this "copy from" does not work on 10g. I'd like to know how to replace that command?

Thanks in advance.

--
dblink defined between DB1 and DB2.

on DB1
   truncate table table1;
   set arraysize 1000
   set copycommit 1
   copy from user/pass_at_DB2 to user/pass_at_DB1 -
           insert table1 using select * from table1;
   quit
Received on Wed Jan 23 2008 - 07:30:39 CST

Original text of this message