Oracle GoldenGate Error Messages

OGG-00419

TARGET doesn't have deferrable constraint when HANDLETPKUPDATE specified


Cause

The parameter file contains the HANDLETPKUPDATE parameter, and the integrity constraints on the target tables are not set to DEFERRABLE. If the target constraints are not DEFERRABLE, Replicat handles the errors according to existing rules specified with the HANDLECOLLISIONS and REPERROR parameters, or else it abends.


Action

Create the constraints on the target tables as DEFERRABLE INITIALLY IMMEDIATE.