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

Last updated on MAY 27, 2023

Applies to:

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

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

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