drop table t_1删除不彻底

SCOTT>select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
DEPT                           TABLE
EMP                            TABLE
BONUS                          TABLE
SALGRADE                       TABLE
BOOK                           TABLE
BIN$sJTwAmEPDVzgQAB/AQAi8A==$0 TABLE
T_EMP                          TABLE
E                              TABLE

在回收站中查看表名

SCOTT>show recyclebin;
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
T_TEST01         BIN$sJTwAmEPDVzgQAB/AQAi8A==$0 TABLE        2011-10-31:00:22:20

彻底删除

SCOTT>purge table T_TEST01;

Table purged.