Re: Updating a remote table with data from a Local Table

It could be possible that you are doing everything right. Errors in the area of 600 are usually indicative of Oracle bugs rather than user accidents.

Is this version 7.3 - I recall having similar problems with unexpected termination
a couple of years ago which was down to an Oracle bug.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Alex Skolnick wrote in message ...
>Hi all you Oracle Gurus,
>
>I have a local table with records I want to move to a Remote table
>with the same table structure. I created a DATABASE LINK and that is
>working fine.
>
>I created my link with the following syntax:
>CREATE DATABASE LINK REMOTE_DB connect to username identified by
>password using 'remoteDATA';
>
>When I use the insert command with the following syntax:
>
>INSERT INTO TEST_ACCT_at_REMOTE_DB SELECT * from LOCAL_DB;
>
>I get the following errors:
>
>INSERT INTO TEST_ACCT_at_REMOTE_DB SELECT * from LOCAL_DB;
> *
>ERROR at line 1:
>ORA-00604: error occurred at recursive SQL level 1
>ORA-01013: user requested cancel of current operation
>ORA-02063: preceding 2 lines from REMOTE_DB
>
>What am I doing wrong?
>
Received on Wed Mar 15 2000 - 16:01:13 CST