-- 下面2个语句都是有时间限制的，一般是900秒内，可以修改参数
SQL> show parameter undo;
alter system set undo_retention=1200;
select id, name, versions_operation, versions_starttime, versions_endtime
from version_table versions between timestamp minvalue and maxvalue;
select id, name, versions_operation, versions_starttime, versions_endtime
from version_table versions between timestamp to_date('2013-06-13 17:50:22', 'yyyy-mm-dd hh24:mi:ss')
and to_date('2013-06-13 18:56:28', 'yyyy-mm-dd hh24:mi:ss');
SQL> show parameter undo;
alter system set undo_retention=1200;
select id, name, versions_operation, versions_starttime, versions_endtime
from version_table versions between timestamp minvalue and maxvalue;
select id, name, versions_operation, versions_starttime, versions_endtime
from version_table versions between timestamp to_date('2013-06-13 17:50:22', 'yyyy-mm-dd hh24:mi:ss')
and to_date('2013-06-13 18:56:28', 'yyyy-mm-dd hh24:mi:ss');
4、 闪回事务查询
create table trans_table(id int,name varchar2(32));
create table trans_table(id int,name varchar2(32));
select * from trans_table t;
insert into trans_table values(4,'ggg');
commit;
insert into trans_table values(2,'bbb');
commit;
insert into trans_table values(3,'ccc');
commit;
delete from trans_table t where t.id = 3;
commit;
select id, name, versions_xid, versions_operation
from trans_table versions between timestamp minvalue and maxvalue;
-- 需要DBA
select table_name,operation,undo_sql from flashback_transaction_query where xid='05000D00AD170000';
insert into "DUMP_TEST"."TRANS_TABLE"("ID","NAME") values ('1','aaa');
insert into trans_table values(4,'ggg');
commit;
insert into trans_table values(2,'bbb');
commit;
insert into trans_table values(3,'ccc');
commit;
delete from trans_table t where t.id = 3;
commit;
select id, name, versions_xid, versions_operation
from trans_table versions between timestamp minvalue and maxvalue;
-- 需要DBA
select table_name,operation,undo_sql from flashback_transaction_query where xid='05000D00AD170000';
insert into "DUMP_TEST"."TRANS_TABLE"("ID","NAME") values ('1','aaa');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769567/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
