WEB开发网
开发学院数据库Oracle Oracle分析ROLLBACK是否产生日志信息 阅读

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

 2012-10-25 16:12:11 来源:WEB开发网   
核心提示: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的日志信息.


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

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

上一页  1 2 3 

Tags:Oracle 分析 ROLLBACK

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接