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
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
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