Removing Delta Conflict Detection and Resolution

The REMOVE_AUTO_CDR_DELTA_RES procedure in the DBMS_GOLDENGATE_ADM package removes delta conflict detection and resolution for a column.

Delta conflict detection and resolution must be configured for the specified column.

Connect to the inbound server database as an Oracle GoldenGate administrator.
Run the REMOVE_AUTO_CDR_DELTA_RES procedure and specify the column.
Repeat all of the previous steps in each Oracle Database that replicates the table.

Example 9-30 Removing Delta Conflict Detection and Resolution for a Table

This example removes delta conflict detection and resolution for the ORDER_TOTAL column in the OE.ORDERS table.

BEGIN
  DBMS_GOLDENGATE_ADM.REMOVE_AUTO_CDR_DELTA_RES(
    SCHEMA_NAME => 'OE',
    TABLE_NAME  => 'ORDERS',
    COLUMN_NAME => 'ORDER_TOTAL');
END;
/