QL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TEST1 BIN$SGHtLJ/KTUOrTO8HY+8x8g==$0 TABLE 2006-10-27:17:34:00

SQL> purge recyclebin
2 ;

回收站已清空。

SQL> show recyclebin
SQL> show parameter recyclebin

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

SQL> alter system set recyclebin=off scope=both;

系統已更改。

[@more@]

oracle10g recyclebin

相關文章