Removing a Column Group

With Oracle Database 23c and higher, removing Automatic Conflict Detection and Resolution (ACDR) from column groups has lesser impact on the table because the ACDR related columns are marked as UNUSED. You can choose to drop a column or retain it at a later stage.

Use the REMOVE_AUTO_CDR_COLUMN_GROUP procedure in the DBMS_GOLDENGATE_ADM package to tag a table, which minimizes blocking. See the example in Removing Conflict Detection and Resolution From a Table.

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

Example 7-16 Removing a Column Group

This example removes the COMPENSATION_CG column group from the HR.EMPLOYEES table. 

BEGIN
  DBMS_GOLDENGATE_ADM.REMOVE_AUTO_CDR_COLUMN_GROUP(
    SCHEMA_NAME       => 'HR',
    TABLE_NAME        => 'EMPLOYEES',
    COLUMN_GROUP_NAME => 'COMPENSATION_CG');
END;
/