Supplemental Logging

Enable supplemental logging and supplemental logging of primary key data and index columns.

To enable supplemental logging, execute these Oracle commands:

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE
 INDEX) COLUMNS;

To verify that minimal supplemental logging and supplemental logging of primary key and unique index information is enabled, enter:

select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, 
SUPPLEMENTAL_LOG_DATA_UI from v$database;

If YES is returned for each column, supplemental logging of primary key information is enabled.

• Table-Level Supplemental Logging
  To replicate updates to user-defined object type attributes, Replication Agent must enable table-level supplemental logging.