To replicate updates to user-defined object type attributes, Replication Agent must enable table-level supplemental logging. Table-level supplemental logging can be enabled manually as follows:
ALTER TABLE THE_TABLE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
Here, THE_TABLE is the name of the table on which supplemental logging is being enabled. Verify that table-level supplemental logging has been enabled with the following command:
select count(*) from ALL_LOG_GROUPS where LOG_GROUP_TYPE='ALL COLUMN LOGGING' and OWNER=THE_OWNER and TABLE_NAME=THE_TABLE
Here, 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.
