4.255 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(255)

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)