When a child table has a referential integrity constraint for the parent table, UPDATE operation in source could cause ORA-02292 error in target.
-- TARGET
-- event_log
Error 2013-05-13 16:59:57.738581 4230 1095809344 s:2 Poster: 12070 - OCITransCommit failed with ORA-2091. (posting from src, queue source, to target) [module osp]
Error 2013-05-13 16:59:57.738839 4230 1095809344 s:2 Poster: failed to commit transaction session 2 in CommitFunc(): ORA-02091: transaction rolled back.ORA-02292: integrity constraint (SCOTT.FK1IESV_PURCHASE_INFO_PM) violated - child record found. Will exit Post.. (posting from src, queue source, to target) [module opo]
Notice 2013-05-13 16:59:57.739952 4230 15013584 Poster: Last committed SCN 21750334. (posting from src, queue source, to target) [module opo]
Info 2013-05-13 16:59:57.743666 3376 2431998352 Poster exited with code=1, pid = 4230 (posting from src, queue source, to target)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center