The recycle bin is actually a data dictionary table containing information about dropped objects.
Oracle maintains a recycle bin for dropped objects starting with Oracle 10g. Dropped tables go "into" the recyclebin, and can be restored (undropped) from the recyclebin.
http://www.dbtalks.com/UploadFile/anjudidi/1213
Oracle maintains a recycle bin for dropped objects starting with Oracle 10g. Dropped tables go "into" the recyclebin, and can be restored (undropped) from the recyclebin. More...