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

From: Alex Skolnick <anon_at_anon.com>
Date: Wed, 15 Mar 2000 12:38:15 -0800
Message-ID: <lnsvcs88daacfvnqtqokkd97n88lhl1ouc@4ax.com>

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 - 14:38:15 CST