Table-Level Supplemental Logging

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

Manually enable table-level supplemental logging by entering:

ALTER TABLE THE_TABLE ADD SUPPLEMENTAL LOG DATA (ALL) 
COLUMNS;

where THE_TABLE is the name of the table on which supplemental logging is being enabled. Verify that table-level supplemental logging has been enabled by executing:

select count(*) from ALL_LOG_GROUPS where 
LOG_GROUP_TYPE='ALL COLUMN LOGGING' and OWNER=THE_OWNER 
and TABLE_NAME=THE_TABLE

where THE_OWNER is the table owner. If this command returns a value of 1, table-level supplemental logging has been enabled for this table.

You can also enable supplemental logging from Replication Agent for Oracle using the ra_set_autocorrection command as described in the Replication Agent Reference Manual.