Skip to Main Content

SQL & PL/SQL

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!

ORA-02291 - ORA-02063 on merge with dml error logging through DB link

413196Jul 14 2009 — edited Jul 15 2009
Hello all,

I have 2 DB's and I would like to merge records from A into B with dml error logging through a db link.
Exemple:
merge into B@dblink
using (select ... from A where...)
when matched then
...
when not matched then
...
log errors into err$_A reject limit unlimited;

When I use this, and exception is thrown:

ORA-02291: integrity constraint (B.constraint_name) violated - parent key not found
ORA-02063: preceding line from dblink

I've got no idea of what causes this.
Could anyone please help me ?

Thanks !

Regards,

TDE.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2009
Added on Jul 14 2009
2 comments
1,303 views