My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.