Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Merge a remote database table using dblink

user585870Nov 11 2013 — edited Nov 11 2013

We have a merge statement running in source database which is merging to a table in remote database using db link. The remote table is partitonoed (interval) table.Source db is 10g and target is 11g.

this merge statement is failing with error saying,

error occurred at recursive SQL level 1

00942: table or view does not exist

ORA-02063: preceding 2 lines from ORCL_ONL_LIVE

If anyone have any idea about this error, please share with us

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2013

Added on Nov 11 2013

#general-database-discussions

3 comments

970 views