Replicat Abends with Error Ora-2292 when Using DEFERREFCONST and HANDLETPKUPDATE
(Doc ID 1471776.1)
Last updated on SEPTEMBER 16, 2020
Applies to:Oracle GoldenGate - Version 220.127.116.11.0 to 18.104.22.168.3 [Release 11.1.1 to 11.2]
Information in this document applies to any platform.
Replicat is attached to an Oracle database release below 12.1
Parent table has a child table with a FK call to PK parent table defined as DEFERRABLE.
Due to an update or delete on child table, replicat shows the following errors:
2012-06-08 10:59:28 WARNING OGG-01154 SQL error 2292 mapping <OWNER>.<PARENT_TABLE> to <OWNER>.<PARENT_TABLE> OCI Error ORA-02292: integrity constraint (<OWNER>.<CHILD_FK>) violated - child record found (status = 2292), SQL .
This is not expected as replicat has been started with parameters: DBOPTIONS DEFERREFCONST
"Replicat abends at RBA xxxxxxx where the delete operation is run on PARENT_TABLE table.
RBA xxxxxxx (which is **AFTER** the above RBA) contains the delete from CHILD_TABLE."
To manage constraints properly, customer has deferred constraints evaluation by setting DBOPTIONS DEFERREFCONST.
Additionally, as updates on primary key are expected, replicat parameter HANDLETPKUPDATE has been added
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document