How to replace the "Copy from" command?
Date: Wed, 23 Jan 2008 05:30:38 -0800 (PST)
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; quitReceived on Wed Jan 23 2008 - 07:30:38 CST