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博客 ” ，链接：https://blog.itpub.net/26937943/viewspace-1210345/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 10g em创建
下一篇：
闪回技术一：闪回查询
请登录后发表评论
登录
全部评论
