Perth, Australia
+ (61) 417713124

Flashback Table, Flashback Database,Flashback Query – examples

  • Posted by Gavin Soorma
  • On July 13, 2009

Oracle Flashback Technology provides a set of features available on 9i or higher version that support viewing and rewinding data back and forth in time to recover from Logical Corruptions while the database is online.

Flashback Technology gives you 6 different ways to track and fix logical corruption through different approach.

Oracle Flashback Query feature lets you specify a target time and then run queries against your database, viewing results as they would have appeared at that time.
Oracle Flashback Version Query lets you view all the versions of all the rows that ever existed in one or more tables in a specified time interval.
Oracle Flashback Transaction Query lets you view changes made by a single transaction, or by all the transactions during a period of time.
Oracle Flashback Table returns a table to its state at a previous point in time.
Oracle Flashback Drop reverses the effects of a DROP TABLE statement.
Oracle Flashback Database provides a more efficient alternative to database point-in-time recovery.

This Document contain the step by step example of how to enable flash back on a DB, how to flash back some deleted rows, how to flash back dropped tables and how to flash back a database for point in time recovery.

Download …



  • Jul 13 2009
Hi Gavin, Very Nice doc. Really helpful to learn. Your blog is awsome Regards Punit

Leave Reply

Your email address will not be published. Required fields are marked *