Oracle GoldenGate Error Messages

OGG-30662

A replica identity mismatch was detected between the base table '{0}' and its partition '{1}'. The replica identity from the child partitions will be applied to the base table for proper processing of INSERT, DELETE, and UPDATE operations.


Cause

The base (parent) table and its corresponding child (partition) table have different replica identity definitions. During processing, Extract identified this mismatch and defaulted to use the replica identity from the child table to maintain consistency in change data application. This condition may occur if the partitioned table's replica identity was altered independently of its parent table or child partition's replica identity deferred from base table due to the default replica identity settings.


Action

Verify that the replica identity settings of the base table and its partitions are consistent in the database. Make sure to set the replica identity settings of the child partitions to match with the DML requirements (if using GETUPDATEBEFORES, NOCOMPRESSUPDATES etc in. parameter file) to avoid potential discrepancies during DML processing.