Altering Conflict Detection and Resolution for a Table

The ALTER_AUTO_CDR procedure in the DBMS_GOLDENGATE_ADM package alters conflict detection and resolution for a table.

Oracle GoldenGate automatic conflict detection and resolution must be configured for the table:

Connect to the inbound server database as the Oracle GoldenGate administrator.
Run the ALTER_AUTO_CDR procedure and specify the table to configure for latest timestamp conflict detection and resolution.
Repeat all of the previous steps in each Oracle Database that replicates the table.

Example 8-12 Altering Conflict Detection and Resolution for a Table

This example alters conflict detection and resolution for the HR.EMPLOYEES table to specify that delete conflicts are tracked in a tombstone table.

BEGIN
  DBMS_GOLDENGATE_ADM.ALTER_AUTO_CDR(
    SCHEMA_NAME       => 'HR',
    TABLE_NAME        => 'EMPLOYEES',
    TOMBSTONE_DELETES => TRUE);
END;
/