ANBOB™

SQL> show parameter recy

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle                  string
db_recycle_cache_size                big integer 0
recyclebin                           string      on

SQL> alter system set recyclebin=off
  2  ;

System altered.

SQL> show user
USER is "SYS"
SQL> conn anbob/anbob
Connected.

SQL> create table testdrop(id integer);

Table created.

SQL> desc testdrop
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                                 NUMBER(38)

SQL> drop table testdrop;

Table dropped.

SQL> show recyclebin
SQL> alter session set recyclebin=on
  2  ;

Session altered.

SQL> create table testdrop(id integer);

Table created.

SQL> drop table testdrop;

Table dropped.

SQL> show recyclebin
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
TESTDROP         BIN$p/SuvHy7sn7gQKjA9QF/dQ==$0 TABLE        2011-07-13:23:00:52

SQL> conn system/oracle
Connected.
SQL> show parameter recycle

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle                  string
db_recycle_cache_size                big integer 0
recyclebin                           string        OFF

note :
recyclebin从系统级关闭，但是可以从session级开放的，最后平时不要禁掉回收站，多了份保障也没什么负担，但表空间不够用时会自动释放

打赏

微信扫一扫，打赏作者吧～