Skip Headers
Oracle® Database Administrator's Guide
11g Release 1 (11.1)

Part Number B28310-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Recovering Tables Using the Flashback Table Feature


You must be using automatic undo management to use the Flashback Table feature. It is based on undo information stored in an undo tablespace.

To understand how to configure your undo tablespace for the Flashback Table feature, see "Undo Space Data Dictionary Views".

The FLASHBACK TABLE statement enables users to recover a table to 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, this Flashback Table feature alleviates the need for you, as the administrator, to perform more complicated point in time recovery operations.

The functionality of the Flashback Table feature can be summarized as follows:

See Also:

Oracle Database Backup and Recovery User's Guide for more information about the FLASHBACK TABLE statement.