Recovering Tables Using Oracle Flashback Table

Oracle Flashback Table enables you to restore a table to its state as of a previous point in time. It provides a fast, online solution for recovering a table that has been accidentally modified or deleted by a user or application. In many cases, Oracle Flashback Table eliminates the need for you to perform more complicated point-in-time recovery operations.

Oracle Flashback Table:

• Restores all data in a specified table to a previous point in time described by a timestamp or SCN.

• Performs the restore operation online.

• Automatically maintains all of the table attributes, such as indexes, triggers, and constraints that are necessary for an application to function with the flashed-back table.

• Maintains any remote state in a distributed environment. For example, all of the table modifications required by replication if a replicated table is flashed back.

• Maintains data integrity as specified by constraints. Tables are flashed back provided none of the table constraints are violated. This includes any referential integrity constraints specified between a table included in the FLASHBACK TABLE statement and another table that is not included in the FLASHBACK TABLE statement.

• Even after a flashback operation, the data in the original table is not lost. You can later revert to the original state.