2、drop
create table flash_table_drop(id int,name varchar2(32));
select * from flash_table_drop t;
insert into flash_table_drop values(1,'aaa');
insert into flash_table_drop values(2,'bbb');
insert into flash_table_drop values(3,'ccc');
create table flash_table_drop(id int,name varchar2(32));
select * from flash_table_drop t;
insert into flash_table_drop values(1,'aaa');
insert into flash_table_drop values(2,'bbb');
insert into flash_table_drop values(3,'ccc');
drop table flash_table_drop;
flashback table flash_table_drop to before drop;
flashback table flash_table_drop to before drop rename to flash_table_drop2;
select * from user_recyclebin t;
flashback table "BIN$XMKrD2OPSUe77HxsS67byg==$0" to before drop rename to flash_table_drop2;
启用、禁用回收站
show parameter recyclebin;
alter session set recyclebin = off;
3、 闪回版本查询（Flashback Version Query）
create table version_table(id int,name varchar2(32));
flashback table flash_table_drop to before drop;
flashback table flash_table_drop to before drop rename to flash_table_drop2;
select * from user_recyclebin t;
flashback table "BIN$XMKrD2OPSUe77HxsS67byg==$0" to before drop rename to flash_table_drop2;
启用、禁用回收站
show parameter recyclebin;
alter session set recyclebin = off;
3、 闪回版本查询（Flashback Version Query）
create table version_table(id int,name varchar2(32));
select * from version_table t;
insert into version_table values(1,'aaa');
commit;
insert into version_table values(2,'bbb');
commit;
update version_table t set t.name = '222bbb' where t.id =2;
commit;
insert into version_table values(3,'ccc');
commit;
insert into version_table values(1,'aaa');
commit;
insert into version_table values(2,'bbb');
commit;
update version_table t set t.name = '222bbb' where t.id =2;
commit;
insert into version_table values(3,'ccc');
commit;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769566/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
