Altering a Column Group

The ALTER_AUTO_CDR_COLUMN_GROUP procedure alters a column group.

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

Example 8-13 Altering a Column Group

This example removes the MANAGER_ID column from the JOB_IDENTIFIER_CG column group for the HR.EMPLOYEES table.

BEGIN
  DBMS_GOLDENGATE_ADM.ALTER_AUTO_CDR_COLUMN_GROUP(
    SCHEMA_NAME        => 'HR',
    TABLE_NAME         => 'EMPLOYEES',
    COLUMN_GROUP_NAME  => 'JOB_IDENTIFIER_CG',
    REMOVE_COLUMN_LIST => 'MANAGER_ID');
END;
/

Note:

If there is more than one column, then use a comma-separated list.