示例如下所示:
exec DBMS_LOGMNR.add_logfile('/archlog/1_1437_879452462.dbf',dbms_logmnr.addfile);
exec DBMS_LOGMNR.START_LOGMNR(OPTIONS =>SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
select SCN, TIMESTAMP, COMMIT_TIMESTAMP,sql_redo,sql_undo from v$logmnr_contents where seg_owner='PMCS' and sql_redolike '%PMCSBEST0101%';
ALTER TABLE"PMCS"."PMCSBEST0101" ADD SUPPLEMENTAL LOG DATA (ALL)COLUMNS;
SQL> select SCN, TIMESTAMP, COMMIT_TIMESTAMP,sql_redo,sql_undo from v$logmnr_contents where seg_owner='PMCS' and sql_redolike '%PMCSBEST0101%';
2.4369E+102016-03-18 11:24:11
ALTERTABLE "PMCS"."PMCSBEST0101" ADD SUPPLEMENTAL LOG DATA (ALL)COLUMNS