Posted by Abishek Kathiresan
Below are the steps to enable recycle bin in oracle 10 & 11g
Step 1: log into sqlplus
SQL> SHOW PARAMETER RECYCLEBIN
NAME TYPE VALUE
————————————————————
recyclebin string on
Step2: To turn ON or OFF the RECYCLEBIN
10g database:
——————-
SQL> ALTER SYSTEM SET recyclebin = OFF;
System altered.
SQL> ALTER SYSTEM SET recyclebin = ON;
System altered.
11g database:
——————
SQL> ALTER SYSTEM SET recyclebin = OFF DEFERRED;
System altered.
SQL> ALTER SYSTEM SET recyclebin = ON DEFERRED;
System altered.
NOTE:
DEFERRED is used because it takes effect in new sessions in the database.
In below scenario
SQL> ALTER SYSTEM SET recyclebin = OFF;
ALTER SYSTEM SET recyclebin = OFF
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option
To enable the recycle bin for a session:
SQL> ALTER SESSION SET recyclebin = ON;
To disable the recycle bin for a session:
SQL> ALTER SESSION SET recyclebin = OFF;
