alter database add supplemental log data;
alter database add supplemental log data (primary key,unique index) columns ;
然后,通过一下命令去查询是否开启:
select supplemental_log_data_min,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI
from v$database;
SUPPLEME SUP SUP
-------- --- ---
YES YES YES