利用flashback_transaction_query表撤销已提交的修改

发布时间：2020-12-15 18:03:04 所属栏目：百科来源：网络整理

导读：select versions_xid,versions_operation ? from test versions between scn minvalue and maxvalue;? ? --SCN select versions_starttime, ?????? versions_endtime, ?????? versions_xid, ?????? versions_operation ? from test versions between timesta

select versions_xid,versions_operation
? from test versions between scn minvalue and maxvalue;?? --SCN

select versions_starttime,
?????? versions_endtime,
?????? versions_xid,
?????? versions_operation
? from test versions between timestamp minvalue and maxvalue;? --Timestamp

select *
? from flashback_transaction_query
?where xid = hextoraw('06000700F3030000');? --Undo SQL

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!