flashback version query

最新推荐文章于 2021-03-29 15:42:54 发布

ciqiyuan9775

最新推荐文章于 2021-03-29 15:42:54 发布

阅读量132

点赞数

--查询数据变更履历(flashback version query)
SELECT versions_startscn,
       versions_starttime,
       versions_endscn,
       versions_endtime,
       versions_xid,
       versions_operation,
       SESSION_ID
FROM LOGIN_LOG
       VERSIONS BETWEEN TIMESTAMP TO_TIMESTAMP ('2014-08-21 18:30:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_TIMESTAMP ('2014-08-21 18:50:00', 'YYYY-MM-DD HH24:MI:SS')
where VERSIONS_OPERATION is not null;

--查询表在时间点的状态
select * from mesprd.NCKITTINGMATERIAL as of timestamp to_timestamp('2011-09-22 12:39:01','YYYY-MM-DD HH24:MI:SS') WHERE machineName='DB123';

--flashback transaction query
SELECT start_scn,
       commit_scn,
       logon_user,
       operation,
       table_name,
       undo_sql
FROM flashback_transaction_query
WHERE xid = '002A001E001FEA1D'

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

转载于:http://blog.itpub.net/15412087/viewspace-1776249/