首页 » ORACLE » recyclebin session on ,system off

recyclebin session on ,system off

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

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Pebbles | #1
    2011-11-11 at 16:01

    That’s 2 cleevr by half and 2×2 clever 4 me. Thanks!