Sat 19 Aug 2006
When you do a drop table on Oracle 10g, you actually don’t drop it, it goes to the Recycle Bin, kind of like Windows. To empty the recycle bin do a purge recyclebin.
Oracle has a good article about this titled Flashback Drop (Recycle Bin).