Jan 28 2008
Flashback Table
All the years I learned that DDL statements in RDBMS world are irrevocable. Once you drop a table it’s just gone; you can’t get that data back easily!
But that isn’t true anymore. “Flashback Tables” in Oracle 10g is at our rescue. Oracle 10g has got similar idea of our recycle-bin. When you execute a drop table statement it drops a table and moves it to recycle-bin, giving you a second chance to survive by restoring it if you have accidentally dropped it. Isn’t that really fantastic!
You can read more on that here. Now execute “drop table” statement without any sweat. 
