recyclebin session on ,system off

原创 Anbob 2011-07-14

553


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级开放的，最后平时不要禁掉回收站，多了份保障也没什么负担，但表空间不够用时会自动释放

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

recyclebin session on ,system off

评论