LogMiner
execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_4_4qmyvk67_.arc',dbms_logmnr.new);
execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_3_4qmyq1bl_.arc',dbms_logmnr.addfile);
execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_3_4qmyq1bl_.arc',dbms_logmnr.removefile);
SELECT * FROM V$logmnr_logs;
execute DBMS_LOGMNR.START_LOGMNR ();
execute DBMS_LOGMNR.START_LOGMNR (510216,510339);
SELECT sql_redo FROM v$logmnr_contents
WHERE username = 'SCOTT' AND operation IN ('DELETE', 'DDL');
EXECUTE DBMS_LOGMNR.START_LOGMNR(options => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
EXECUTE DBMS_LOGMNR.START_LOGMNR(510216,510339,options => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
SELECT sql_redo FROM v$logmnr_contents
WHERE username = 'SCOTT' AND operation IN ('DELETE', 'DDL');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16348200/viewspace-543117/ ，如需转载，请注明出处，否则将追究法律责任。
