How to Check, Disable and Enable Recyclebin in Oracle Database

_____________________________________________________________________________________________________________________

Check whether recyclebin is enabled or not using below commands.

SQL> show parameter recyclebin

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



select name,value from v$parameter where name like '%recyclebin%'
/

NAME                VALUE
-------------------- --------------------
recyclebin          ON
Turn off the recyclebin using below command. You should use deferred option while disabling and enabling the recyclebin. It will be disabled or enabled only for the subsequent database sessions.

SQL> alter system set recyclebin=off deferred;

System altered.

SQL> show parameter recyclebin

NAME                              TYPE      VALUE
------------------------------------ ----------- ------------------------------
recyclebin                        string    on
SQL> conn / as sysdba
Connected.
SQL> show parameter recyclebin

NAME                              TYPE      VALUE
------------------------------------ ----------- ------------------------------
recyclebin                        string    OFF

Turn On the recyclebin using below command.

SQL> alter system set recyclebin=on deferred;

System altered.

SQL> show parameter recyclebin

NAME                              TYPE      VALUE
------------------------------------ ----------- ------------------------------
recyclebin                        string    OFF
SQL> conn / as sysdba
Connected.
SQL> show parameter recyclebin

NAME                              TYPE      VALUE
------------------------------------ ----------- ------------------------------
recyclebin                        string    ON
SQL>

_____________________________________________________________________________________________________________________

0 comments:

Post a comment

 

acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer