How to Check, Disable and Enable Recyclebin in Oracle Database

advertisements

_____________________________________________________________________________________________________________________

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.

advertisements

 

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>

_____________________________________________________________________________________________________________________

Website Stats