IF user drops a very important table--accidentally, of course--and it needs to be revived as soon as possible.
Oracle9i Database introduced the concept of a Flashback Query option to retrieve data from a point in time in the past, but it can't flash back DDL operations such as dropping a table.
The only re-course is to use tablespace point-in-time recovery in a different database and then recreate the table in the current database using export/import or some other method
Oracle 10g provides excellent method for same :
http://www.oracle.com/technology/pub/articles/10gdba/week5_10gdba.htmlRegards,
Ashish
Author