6.6. Using Flashback Table
Flashback Table is a Flashback Technology that allows you to recover a table or set tables to a specific point-in-time without performing an incomplete recovery. All dependent objects are also recovered when using Flashback Table.
Flashback Table has some significant benefits over incomplete recovery:
It is much faster and easier to use than incomplete recovery.
Flashback Table does not impact the availability of the database.
The DBA is not required to perform Flashback Table, so users can quickly recover from logical corruptions.
Like other Flashback Technologies, the Flashback Table is based on undo data and utilizes the UNDO_RETENTION initialization parameter to determine the amount of time to retain committed undo ...
Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
