HOWTO Really Delete Tables On Oracle 10g
by Frank Kim on Aug.19, 2006, under Oracle
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).
Related posts: