使用logmnr的练习

 select * from t_1126 t for update;--DML

 exec dbms_logmnr.add_logfile('D:\DISK3\REDO01A.LOG',dbms_logmnr.new)--添加重做日志

 exec dbms_logmnr.start_logmnr-
 (options=>dbms_logmnr.dict_from_online_catalog + -
 dbms_logmnr.committed_data_only + -
 dbms_logmnr.print_pretty_sql);
 
 
 select sql_redo from v$logmnr_contents where seg_name='T_1126';