DBA_FLASHBACK_ARCHIVE
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 FLASHBACK_ARCHIVE_NAME                                NOT NULL VARCHAR2(255)
 FLASHBACK_ARCHIVE#                                    NOT NULL NUMBER
 RETENTION_IN_DAYS                                     NOT NULL NUMBER
 CREATE_TIME                                                    TIMESTAMP(9)
 LAST_PURGE_TIME                                                TIMESTAMP(9)
 STATUS                                                         VARCHAR2(7)

使用例
PROD(SYS)> col FLASHBACK_ARCHIVE_NAME format a10
PROD(SYS)> col CREATE_TIME format a35
PROD(SYS)> col LAST_PURGE_TIME format a35
PROD(SYS)> select * from  dba_flashback_archive;

FLASHBACK_ FLASHBACK_ARCHIVE# RETENTION_IN_DAYS CREATE_TIME                         LAST_PURGE_TIME                     STATUS
---------- ------------------ ----------------- ----------------------------------- ----------------------------------- -------
FDA                         1                90 05-DEC-09 09.56.37.000000000 AM     05-DEC-09 09.56.37.000000000 AM     DEFAULT
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License