ORACLE 11G以上版本开启追加日志的命令

郑全

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