--查看回收站中的信息

18:50:57 scott@TESTDB11>show recyclebin;

ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME

---------------- ------------------------------ ------------ -------------------

EMP1             BIN$47WerktYBe/gRAgAJzxnug==$0 TABLE        2013-08-11:18:46:42   

--进一步确定这就是我们删除的emp1表

19:14:29 scott@TESTDB11>select * from "BIN$47WerktYBe/gRAgAJzxnug==$0";

no rows selected

19:16:03 scott@TESTDB11>desc "BIN$47WerktYBe/gRAgAJzxnug==$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)

--闪回删除

19:17:41 scott@TESTDB11>flashback table "BIN$47WerktYBe/gRAgAJzxnug==$0" to before drop;

Flashback complete.

19:17:59 scott@TESTDB11>select * from emp1;

no rows selected

--清空回收站

19:18:04 scott@TESTDB11>drop table emp1;

Table dropped.

19:18:58 scott@TESTDB11>show recyclebin;

ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME

---------------- ------------------------------ ------------ -------------------

EMP1             BIN$47WerktZBe/gRAgAJzxnug==$0 TABLE        2013-08-11:19:18:58

19:19:06 scott@TESTDB11>purge recyclebin;

Recyclebin purged.

19:19:10 scott@TESTDB11>show recyclebin;

--删除时不进入回收站,直接干掉

19:20:04 scott@TESTDB11>drop table student1 purge;

Table dropped.

19:20:14 scott@TESTDB11>show recyclebin;