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:
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, then supplemental logging of primary key information is enabled.
