Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_FLASHBACK_ARCHIVE

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
OWNER_NAME VARCHAR2(30)   Name of the creator of the flashback archive
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)