How to Defer Oracle Constraint Checking until the End of the Transaction?

(Doc ID 1331306.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Replicat abends with unique constraint error processing transaction data, for example:

OCI Error ORA-00001: unique constraint (CORE.PERSON_PK) violated (status = 1), SQL <INSERT INTO "CORE"."PERSON" ("PART_NUM","PARTY_NUM","BIRTH_DATE","DCEASD_DATE","STD_TITLE_CODE","BIRTHDT_AUDIT_NUM","DCEASD_IND","SMALL_BUS_OWNR_IND","GNDR_CODE","CUSTOM_TITLE_NAME","PRSNL_FRST_NAME",>
Aborting transaction on /dbfs_direct/POCDATA/goldengate/p1/dirdat/co beginning at seqno 0 rba 963
error at seqno 0 rba 1624

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