闪回事务查询+闪回事务查询案例

闪回事务查询
1闪回事务查询是闪回版本查询的一个扩充
2闪回事务查询可以审计某个事务或者撤销一个已经提交的事务

闪回事务查询案例

测试数据

create table sct4(
id number(4), 
name varchar2(20)
);
insert into sct4 values(1,'lili');
commit;
insert into sct4 values(2,'lilic');
commit;
delete sct4   where id=1;
commit;

--列格式
set linesize 200;
column id format 99;
column name format a20;
column versions_xid format a20;
column versions_operation format a10;
column versions_starttime format a25;
column versions_endtime format a25;

column xid format a20;
column operation format a20;
column table_name format a20;
column undo_sql format a20;

获取事务的xid

  select id, name,versions_xid,versions_operation,versions_starttime,versions_endtime
  from sct4
  versions  between  timestamp  minvalue  and maxvalue
  order by id,versions_endtime;

对应事务的闪回事务查询

撤销对应事务