DBA_FLASHBACK_ARCHIVE_TS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FLASHBACK_ARCHIVE_NAME                    NOT NULL VARCHAR2(255)
 FLASHBACK_ARCHIVE#                        NOT NULL NUMBER
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 QUOTA_IN_MB                                        VARCHAR2(40)

使用例:
PROD(SYS)> set lines 120
PROD(SYS)> col FLASHBACK_ARCHIVE_NAME format a10
PROD(SYS)> select * from dba_flashback_archive_ts;

FLASHBACK_ FLASHBACK_ARCHIVE# TABLESPACE_NAME                QUOTA_IN_MB
---------- ------------------ ------------------------------ ----------------------------------------
FDA                         1 FDA01                          2048
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License