Replicat Abends with Error Ora-2292 when Using DEFERREFCONST and HANDLETPKUPDATE
Last updated on MAY 16, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 to 126.96.36.199.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 9763187 where the delete operation is run on PARENT_TABLE table.
RBA 9763305 (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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms