Object Type Attribute Replication

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.

Replication Agent also attempts to enable this logging when marking a table that contains a user-defined object type. However, for Replication Agent to mark such a table, there must already be an Oracle user specified by the pds_username parameter that has ALTER permission granted for the table.

If table-level supplemental logging has not been enabled for a table containing a user-defined object type and Replication Agent encounters an update log record in the Oracle log, Replication Agent changes its status from Replicating to Admin with this error:

There is insufficient column data in the log to support Oracle UDD update command processing. Please make sure table-level supplemental logging is enabled.

In this case, use the pdb_skip_op to skip this log record. See the Replication Agent Reference Manual.