1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Error Management
  4. Automatic Conflict Detection and Resolution
  5. Monitoring Automatic Conflict Detection and Resolution
  6. Displaying Information About Column Groups

Displaying Information About Column Groups

The ALL_GG_AUTO_CDR_COLUMN_GROUPS view displays information about the column groups configured for Oracle GoldenGate automatic conflict detection and resolution.
You can configure Oracle GoldenGate automatic conflict detection and resolution using the ADD_AUTO_CDR procedure in the DBMS_GOLDENGATE_ADM package. You can configure column groups using the ADD_AUTO_CDR_COLUMN_GROUP procedure in the DBMS_GOLDENGATE_ADM package.
  1. Connect to the database as an Oracle GoldenGate administrator.
  2. Query the ALL_GG_AUTO_CDR_COLUMN_GROUPS view.

Example 8-20 Displaying Information About Column Groups

This query displays the following information about the tables that are configured for conflict detection and resolution:

  • The table owner.

  • The table name.

  • The name of the column group.

  • The hidden timestamp column used for conflict resolution for each column group.

COLUMN TABLE_OWNER FORMAT A15
COLUMN TABLE_NAME FORMAT A15
COLUMN COLUMN_GROUP_NAME FORMAT A20
COLUMN RESOLUTION_COLUMN FORMAT A25

SELECT TABLE_OWNER,
       TABLE_NAME, 
       COLUMN_GROUP_NAME,
       RESOLUTION_COLUMN 
  FROM ALL_GG_AUTO_CDR_COLUMN_GROUPS
  ORDER BY TABLE_OWNER, TABLE_NAME;

The output looks similar to the following:

TABLE_OWNER     TABLE_NAME      COLUMN_GROUP_NAME    RESOLUTION_COLUMN
--------------- --------------- -------------------- -------------------------
HR              EMPLOYEES       COMPENSATION_CG      CDRTS$COMPENSATION_CG
HR              EMPLOYEES       JOB_IDENTIFIER_CG    CDRTS$JOB_IDENTIFIER_CG