库级别

alter database add supplemental log data;
alter database add supplemental log data(primary key,unique) columns;

表级别
alter table scott.emp drop supplemental log data(all) columns;
alter table scott.emp add supplemental log data(all) columns;

查看
set linesize 200 pagesize 200
col owner for a20
col LOG_GROUP_NAME for a20
col TABLE_NAME for a20
select * from ALL_LOG_GROUPS;

select
LOG_MODE,
SUPPLEMENTAL_LOG_DATA_MIN,
SUPPLEMENTAL_LOG_DATA_PK,
SUPPLEMENTAL_LOG_DATA_UI,
FORCE_LOGGING,
SUPPLEMENTAL_LOG_DATA_FK,
SUPPLEMENTAL_LOG_DATA_ALL,
SUPPLEMENTAL_LOG_DATA_PL
from v$database;

LOG_MODE SUPPLEME SUP SUP FOR SUP SUP SUP
------------ -------- --- --- --- --- --- ---
NOARCHIVELOG YES YES YES NO NO NO NO

select LOGGING from dba_tables;