Page Comparison

...

The following SQL is run by Dbvisit Replicate to turn on supplemental logging

SQL> alter database add supplemental log data;

If DDL is enabled, then the following is run

SQL> alter database add supplemental log data (primary key) columns;

For each table to be replicated the following SQL is run

SQL> alter table '||owner||'.'||table_name||' add supplemental log data (primary key) columns;

The supplemental log groups created by Dbvisit Replicate start with a G and then a random hex string: G575B4B0CC2E511E2A20CB8ADB3813

...

To check and monitor what supplemental logging has been turned on, the following query can be run

SQL> SELECT supplemental_log_data_min MIN, 

supplemental_log_data_pk PK, 

supplemental_log_data_ui UI, 

supplemental_log_data_fk FK,

supplemental_log_data_all "ALL" 

FROM v$database;

Modifying supplemental log behaviour

...