DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 18, 2017

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;

No comments: