Thursday 21 March 2013

RECYCLE BIN IN ORACLE:

RECYCLE BIN IN ORACLE:


SQL > SELECT Value FROM V$parameter WHERE Name = 'recyclebin';

Value
-----
On

SQL > ALTER SYSTEM SET recyclebin = ON;
or
SQL > ALTER SESSION SET recyclebin = ON;

SQL > ALTER SYSTEM SET recyclebin = OFF;
or
SQL > ALTER SESSION SET recyclebin = OFF;





Refrence:

 http://www.orafaq.com/node/2397

No comments:

Post a Comment