笔记：数据库日志挖掘信息不完整

在进行的一次数据挖掘过程中，查询出的信息好多都不完整甚至是空的

此时可以尝试打开最小附加日志

查询附加日志选项

select supplemental_log_data_min,
       supplemental_log_data_pk,
       supplemental_log_data_ui,
       supplemental_log_data_fk,
       supplemental_log_data_all
  from v$database;

开启最小附加日志

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;

开启标识键日志

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;  
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;  
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;  
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

关闭附加日志

ALTER DATABASE drop SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;  
ALTER DATABASE drop SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;  
ALTER DATABASE drop SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;  
ALTER DATABASE drop SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

alter database drop supplemental log data;

附加日志相关内容：
附加日志