Thursday, October 05, 2006

Oracle 10g Recyclebin

To disable the recycle bin:

ALTER SESSION SET recyclebin = OFF;
ALTER SYSTEM SET recyclebin = OFF;

To enable the recycle bin:

ALTER SESSION SET recyclebin = ON;
ALTER SYSTEM SET recyclebin = ON;

To check what objects are in the recycle bin:

select * from user_recyclebin;
select * from dba_recyclebin;

To purge the objects in the recycle bin:

purge recyclebin;
purge dba_recyclebin;

No comments: