Restore the entire database to a specific point-in-time, using Oracle-optimized flashback logs, rather than via backups and forward recovery.
Easily recover tables to a specific point-in-time. The feature is extremely useful when a logical corruption is limited to one or a set of tables instead of the entire database.
Recover an accidentally dropped table. The feature restores the dropped table, and all its indexes, constraints, and triggers, from the Recycle Bin (a logical container of all dropped objects).
Undo the effects of a single transaction, and optionally, all its dependent transactions. via a single PL/SQL operation or by using an Enterprise Manager wizard.
View all the changes made by a specific transaction. The feature is useful when an erroneous transaction changed data in multiple rows or tables.
Query any data at some point-in-time in the past. This powerful feature can be used to view and logically reconstruct corrupted data that may have been deleted or changed inadvertently.
Retrieve different versions of a row across a specified time interval instead of a single point-in-time.
Efficiently manage and query long-term historical data. Flashback Time Travel automatically tracks every transactional change made to database data and maintains a secure, and easily accessible, archive of historic data.