...
Please see variable _ADD_SUPLOG in Internal Variables on the default supplemental log behaviour and how to modify this.
How Dbvisit Replicate works with supplemental logging
Dbvisit Replicate does not use primary key definition directly. It uses all the columns that are supplementally logged by Oracle.
When a table is prepared, Dbvisit Replicate issues: alter table xx.xx add supplemental logging (primary key) columns.
This enables the following Oracle behaviour:
- If there is an enabled PK, it will add supplemental logging to only the columns of the PK
- If there is no PK, but there is unique key that is guaranteed to be unique (none of the columns are NULL) - use columns of this UK
- As last resort, log all columns (except those that can never be logged - LOBs, LONGs, nested tables etc.)
This means that as long as there is a way on how to uniquely identify rows, replication will work as expected. Oracle will supplementally log all the columns needed.