Square DBA – Oracle DBA Talk

Did you know Oracle has a recycle bin? When you drop a table it goes into the recycle bin assuming you have the feature turned on. If you are trying to reclaim space simply dropping a table will not do it. You need to also purge the table from the recycle bin.

You can purge and individual table like this:

PURGE TABLE ;

Or you can purge based on tablespace like this:

PURGE TABLESPACE ;

Or how about based on tablespace and by user:

PURGE TABLESPACE  USER 

To purge your entire recycle bin run this:

PURGE RECYCLEBIN;

or to purge everyone’s recycle bin run this:

PURGE DBA_RECYCLEBIN;