ZT 去掉logmnr中SQL_UNDO的rowid

原地址:

http://www.itpub.net/viewthread.php?tid=965512

 

使用dbms_logmnr.no_rowid_in_stmt

SQL> exec dbms_logmnr.add_logfile('D:ORACLEORADATAP10GONLINELOGO1_MF_3_3YY73S04_.LOG');

PL/SQL 过程已成功完成。

SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);

PL/SQL 过程已成功完成。
SQL> select sql_undo from v$logmnr_contents where dbms_logmnr.column_present(redo_value,'XHUSER.CLOB_TEST.ID')=1;

SQL_UNDO
--------------------------------------------------------------------------------
delete from "XHUSER"."CLOB_TEST" where "ID" = '1' and ROWID = 'AAAAAAAAAAAAAAAAAA';

SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog+dbms_logmnr.no_rowid_in_stmt);

PL/SQL 过程已成功完成。

SQL> select sql_undo from v$logmnr_contents where dbms_logmnr.column_present(redo_value,'XHUSER.CLOB_TEST.ID')=1;

SQL_UNDO
--------------------------------------------------------------------------------
delete from "XHUSER"."CLOB_TEST" where "ID" = '1';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/386081/viewspace-402146/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/386081/viewspace-402146/