Turning on Supplemental Logging at Table Level and Turning off Supplemental Logging at Database Level

Turn off supplemental logging at database level and turn on supplemental logging at table level.

Note: You can switch between supplemental logging at database level and table level at any point in time. However, you must not turn off supplemental logging at database level before you turn on supplemental logging at table level because it takes some amount of time for switching. During this period, Oracle does not write the PK and UI columns to the redo log file, until the supplemental logging at table level is turned on. This can cause Replication Agent to go to the Replication Down state.

Run:
ra_admin supplemental_logging_level, table
The command generates an SQL script at this location:
$SYBASE/RAX-15_5/<instance_name>/script/prepare/prepare_pdb_for_table_level.sql

Note: You must have a database administrator role to perform step 2.
Run the SQL script:
$SYBASE/RAX-15_5/<instance_name>/script/prepare/prepare_pdb_for_table_level.sql
The script turns on table level primary key and unique supplemental logging of the required Oracle system tables, already marked user tables, and Replication Agent system tables.