Oracle GoldenGate Error Messages

OGG-30127

The Replica identity setting for the table '{0}' is set to 'DEFAULT' which is not sufficient to process the DELETE operation for table without a primary key. Set the Replica identity setting to FULL using the ADD TRANDATA '{0}', ALLCOLS command and re-initiate the DML in the problematic table.


Cause

The Replica identity setting for the table is set to DEFAULT, which is not compatible to process the DELETE operation for a table without a primary key.


Action

Set the Replica identity setting to FULL using the ADD TRANDATA with ALLCOLS command and re-initiate the DML in the problematic table.