Oracle GoldenGate Error Messages

OGG-05372

The foreign key constraint in table {0} is not enforced on insert, update, or delete operations executed on this connection.


Cause

The foreign key in the specified table is set to NOT FOR REPLICATION. In this mode, The target database does not enforce the foreign key constraint when insert, update, or delete operation is performed by Replicat operating as a replication agent. This includes CASCADE operations. The assumption is that the constraint was checked on the source database and that the cascaded operations are captured and replicated.


Action

Make sure that the referenced tables are included in the replication configuration with the referencing table to see alerts for integrity violations, such as if a row gets inserted into a table that contains a foreign key to a non-replicated table.