Oracle GoldenGate Error Messages

OGG-01168

Encountered an update for target table {0}, which has no unique key defined. KEYCOLS can be used to define a key. Use ALLOWNOOPUPDATES to process the update without applying it to the target database. Use APPLYNOOPUPDATES to force the update to be applied using all columns in both the SET and WHERE clause.


Cause

Replicat tried to apply a record by using a unique key for row selection, but a matching key does not exist in the target table.


Action

If the source and target tables do not have identical key columns, use an identical KEYCOLS clause in the source TABLE parameter and the target MAP parameter. For more information about KEYCOLS, see the Oracle GoldenGate reference documentation. To learn about ALLOWNOOPUPDATES and APPLYNOOPUPDATES, contact Oracle Support.