Oracle分析ROLLBACK是否产生日志信息

核心提示：2 from v$logmnr_contents3 where lower(sql_redo) like '%tt002%' and lower(sql_redo) like '%delete%';TIMESTAMP SCN

2 from v$logmnr_contents
3 where lower(sql_redo) like '%tt002%' and lower(sql_redo) like '%delete%';

TIMESTAMP SCN
------------------- ----------
SQL_REDO
--------------------------------------------------------------------------------
2012-10-25 11:36:26 3813606
delete from "TEST"."TT002" where ROWID = 'AAAS0lAAEAAAAFbAGB';

2012-10-25 11:36:26 3813606
delete from "TEST"."TT002" where ROWID = 'AAAS0lAAEAAAAFbAGA';

2012-10-25 11:36:26 3813606
delete from "TEST"."TT002" where ROWID = 'AAAS0lAAEAAAAFbAF/';

.....

也就是说回滚INSERT对应产生了DELETE的日志信息.

-----------------------------------------------------------------

如此文有错误,欢迎指正,顺便告诫自己一定要多动手,实践才能出真理,切勿想当然.