闪回删除实验

--查看回收站功能是否打开
SYS@PROD1> show parameter recyclebin

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
recyclebin			     string	 on

--模拟闪回删除
SYS@PROD1> conn scott/tiger
Connected.
SCOTT@PROD1> create table e as select * from emp;

Table created.

SCOTT@PROD1> drop table e;

Table dropped.

SCOTT@PROD1> create table e as select * from dept;

Table created.

SCOTT@PROD1> drop table e;

Table dropped.

SCOTT@PROD1> show recyclebin  --有两个相同的表e
ORIGINAL NAME	 RECYCLEBIN NAME		OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
E		 BIN$RMuxCbAfEP/gU0edqMDlhQ==$0 TABLE	     2016-12-29:21:02:12
E		 BIN$RMuxCbAeEP/gU0edqMDlhQ==$0 TABLE	     2016-12-29:21:02:02
SCOTT@PROD1> desc "BIN$RMuxCbAfEP/gU0edqMDlhQ==$0"
 Name						       Null?	Type
 ----------------------------------------------------- -------- ------------------------------------
 DEPTNO 							NUMBER(2)
 DNAME								VARCHAR2(14)
 LOC								VARCHAR2(13)

SCOTT@PROD1> desc "BIN$RMuxCbAeEP/gU0edqMDlhQ==$0"
 Name						       Null?	Type
 ----------------------------------------------------- -------- ------------------------------------
 EMPNO								NUMBER(4)
 ENAME								VARCHAR2(10)
 JOB								VARCHAR2(9)
 MGR								NUMBER(4)
 HIREDATE							DATE
 SAL								NUMBER(7,2)
 COMM								NUMBER(7,2)
 DEPTNO 							NUMBER(2)

SCOTT@PROD1> flashback table "BIN$RMuxCbAfEP/gU0edqMDlhQ==$0" to before drop;

Flashback complete.

SCOTT@PROD1> desc e
 Name						       Null?	Type
 ----------------------------------------------------- -------- ------------------------------------
 DEPTNO 							NUMBER(2)
 DNAME								VARCHAR2(14)
 LOC								VARCHAR2(13)

SCOTT@PROD1> show recycle bin
SCOTT@PROD1> show recyclebin
ORIGINAL NAME	 RECYCLEBIN NAME		OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
E		 BIN$RMuxCbAeEP/gU0edqMDlhQ==$0 TABLE	     2016-12-29:21:02:02

--表名存在需要rename to改名。
SCOTT@PROD1> flashback table "BIN$RMuxCbAeEP/gU0edqMDlhQ==$0" to before drop rename to old_e;

Flashback complete.

SCOTT@PROD1> desc old_e  
 Name						       Null?	Type
 ----------------------------------------------------- -------- ------------------------------------
 EMPNO								NUMBER(4)
 ENAME								VARCHAR2(10)
 JOB								VARCHAR2(9)
 MGR								NUMBER(4)
 HIREDATE							DATE
 SAL								NUMBER(7,2)
 COMM								NUMBER(7,2)
 DEPTNO 							NUMBER(2)

--清空回收站
SCOTT@PROD1> purge recyclebin;  --清当前

Recyclebin purged.

SYS@PROD1> purge dba_recyclebin;  --清所有

DBA Recyclebin purged.