Steps to enable recyclebin in oracle 10 & 11g:


SQL> SHOW PARAMETER RECYCLEBIN

NAME                                 TYPE        VALUE
————————————————————
recyclebin                           string      on

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.

DEFERRED is used because it takes effect in new sessions in the database.

case :

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;

  • January 18, 2017 | 17 views
  • Comments