Table-level supplemental logging

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.