Oracle 10+ Recyclebin

Oracle 10 maintains a 'recyclebin' for dropped tables, 'used' space will be freely overwritten by new tables if you are out of unused space. Names of dropped tables are prefixed with ‘BIN$’. You can disable this function if you want all traces of the dropped tables gone.

Empty the trash:

PURGE recyclebin;

Disable for session:

alter session set recyclebin=off;

Disable for system:

alter system set recyclebin=off;