oracle闪回学习六

闪回删除表
SQL> create table emp tablespace users as select * from hr.employees;

Table created.


SQL> select count(*) from emp;

  COUNT(*)
----------
       107


SQL> drop table emp;

Table dropped.


SQL> flashback table emp to before drop;

Flashback complete.


SQL> select count(*) from emp;

  COUNT(*)
----------
       107
  
  
  
SQL> drop table emp;

Table dropped.


回收站对象本身也可以被查询
SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
EMP BIN$8TBReJuwGUvgQ4swqMDQDw==$0 TABLE     2014-01-30:20:39:03

回收站对象本身也可以被查询
SQL> select count(*) from "BIN$8TBReJuwGUvgQ4swqMDQDw==$0";

  COUNT(*)
----------
       107


将回收站对象取出，并命名一个新名字
SQL> flashback table emp to before drop rename to empold;

Flashback complete.