Replicat Abends with Error Ora-2292 when Using DEFERREFCONST and HANDLETPKUPDATE (Doc ID 1471776.1)

Last updated on MAY 16, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 to 11.2.1.0.3 [Release 11.1.1 to 11.2]
Information in this document applies to any platform.

Symptoms

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."

Changes

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

Cause

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