Saturday, June 22, 2013

Managing Recycle bin

Display the contents of the recycle bin :-

show recyclebin

or
SQL> select * from dba_recyclebin; (to see purge table of all schema )
SQL> select * from recyclebin; (to see purge table of own schema)

Empty the recycle bin:- 

purge recyclebin;
purge dba_recyclebin ( to purge tables of all schema)

Drop an object with out putting it in the recycle bin :- 

drop purge;

To see total size taken by recyclebin :-

SQL> select sum(bytes)/1024/1024/1024 from dba_segments where segment_name in (s
elect object_name from dba_recyclebin);

SUM(BYTES)/1024/1024/1024
-------------------------

23.64

No comments:

Post a Comment

Followers