Oracle Flashback Technologies - 闪回被drop的表
在oracle10g中,drop一个表后,表没有真正被删除,支持被rename后放在recyclebin中。
#新建一个表y2,用来测试
SQL> create table y2 as select * from all_tables; Table created. SQL> select count(*) from y2; COUNT(*)
----------
#删除表
SQL> show recyclebin
SQL> drop table y2; Table dropped. SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
Y2 BIN$GSUg65H6LKDgU7wMCgqm8g==$ TABLE --:::
SQL> select count(*) from y2;
select count(*) from y2
*
ERROR at line :
ORA-: table or view does not exist
#闪回被drop的表
SQL> flashback table y2 to before drop; Flashback complete. SQL> select count(*) from y2; COUNT(*)
---------- SQL> show recyclebin
SQL>