Return
-
Title
ORA-02292 in target when a table has a self-referential FK -
Description
When a child table has a self-referential integrity constraint, DELETE operation in source could cause ORA-02292 error in target.
-- TARGET
-- event_log
Error 2017-06-28 14:20:34.329830 9194 1099897152 s:3 Table "SCOTT"."S_FK_TEST" out of sync for queue source at source rowid AAAfKiAAEAAAADVAAA: ORA-02292: integrity constraint (SCOTT.S_FK_TEST_HIREARCHY_FK) violated - child record found (posting from source1, queue source, to source)
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.