Saturday, 12 September 2015

Foreign Key Issues in Oracle GoldenGate

Please check ggerror.log file :

Database error 2292 (OCI Error ORA-02292: integrity constraint (CRA.PT_PT_FK) violated - child record found (status = 2292), SQL <DELETE FROM "CRA"."PROJTASK"  WHERE "PROJTASKID" = :b0>).

Solution:

Disable the foreign key on the mirror database and restart process.

No comments:

Post a Comment