In Oracle release 9.2 and later, minimal supplemental logging and supplemental logging of primary key data and index columns must be enabled. To enable supplemental logging, execute the following Oracle commands enter the following:
alter database add SUPPLEMENTAL LOG DATA; alter database add SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;
To verify that minimal supplemental logging and supplemental logging of primary key and unique index information is enabled:
select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI from v$database;
If YES is returned for each column, supplemental logging of primary key information is enabled.
