How to replace the "Copy from" command?
From: nionio_usa <antonio.botelho_at_arc-intl.com>
Date: Wed, 23 Jan 2008 05:30:38 -0800 (PST)
Message-ID: <0e5fa5f0-196f-442e-9527-69f1442bde3d@c4g2000hsg.googlegroups.com>
Date: Wed, 23 Jan 2008 05:30:38 -0800 (PST)
Message-ID: <0e5fa5f0-196f-442e-9527-69f1442bde3d@c4g2000hsg.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; quitReceived on Wed Jan 23 2008 - 07:30:38 CST