1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
  4. DBA_FLASHBACK_ARCHIVE_TS

4.255 DBA_FLASHBACK_ARCHIVE_TS

DBA_FLASHBACK_ARCHIVE_TS describes all tablespaces in the flashback archives available in the database.

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

TABLESPACE_NAME

VARCHAR2(30)

NOT NULL

Name of a tablespace in the flashback archive

QUOTA_IN_MB

VARCHAR2(40)

Maximum space (in MB) that can be used for Flashback Archive from the tablespace; NULL indicates no Quota restriction