Flashback Table

Flashback Table

It is the ability to recover a table up to a specified time in the past.It restores tables while automatically maintaining associated attributes such as current indexes, triggers and constraints.

FLASHBACK TABLE inventory TO TIMESTAMP

     TO_TIMESTAMP('2011-02-04 09:30:00', `YYYY-MM-DD HH24:MI:SS'); 

Now smile:-)