Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-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


DBA_FLASHBACK_ARCHIVE describes all flashback archives available in the database.

Related View

USER_FLASHBACK_ARCHIVE describes the flashback archives available to the current user.

Column Datatype NULL Description
FLASHBACK_ARCHIVE_NAME VARCHAR2(255) NOT NULL Name of the flashback archive
FLASHBACK_ARCHIVE# NUMBER NOT NULL Number of the flashback archive
RETENTION_IN_DAYS NUMBER NOT NULL Maximum duration (in days) for which data is retained in the flashback archive
CREATE_TIME TIMESTAMP(9)   Time at which the flashback archive was created
LAST_PURGE_TIME TIMESTAMP(9)   Time at which the data in the flashback archive was last purged by the system
STATUS VARCHAR2(7)   Indicates whether the flashback archive is a default flashback archive for the system (DEFAULT) or not (NULL)