SQL> select original_name,droptime,dropscn from dba_recyclebin;
ORIGINAL_NAME DROPTIME DROPSCN
-------------------------------- ------------------- ----------
T 2014-07-05:15:37:00 954028
T 2014-07-05:15:39:47 954133
SQL> purge table t;
表已清除。
SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
T BIN$LuLxhgmFTfO3QszF66Gi3Q==$0 TABLE 2014-07-05:15:39:47
SQL> select original_name,droptime,dropscn from dba_recyclebin;
ORIGINAL_NAME DROPTIME DROPSCN
-------------------------------- ------------------- ----------
T 2014-07-05:15:39:47 954133
清空了先进回收站的表.
ORIGINAL_NAME DROPTIME DROPSCN
-------------------------------- ------------------- ----------
T 2014-07-05:15:37:00 954028
T 2014-07-05:15:39:47 954133
SQL> purge table t;
表已清除。
SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
T BIN$LuLxhgmFTfO3QszF66Gi3Q==$0 TABLE 2014-07-05:15:39:47
SQL> select original_name,droptime,dropscn from dba_recyclebin;
ORIGINAL_NAME DROPTIME DROPSCN
-------------------------------- ------------------- ----------
T 2014-07-05:15:39:47 954133
清空了先进回收站的表.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26937943/viewspace-1210345/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26937943/viewspace-1210345/