SQL> create tablespace FDA1 datafile '/s01/app/oracle/oradata/DB11G/FDA01.dbf' size 50M;Tablespace created.SQL> create flashback archive fla1 tablespace FDA1 retention 1 MONTH;Flashback archive created.SQL> col FLASHBACK_ARCHIVE_NAME for a30SQL> select FLASHBACK_ARCHIVE_NAME,status from dba_flashback_archive 2 /FLASHBACK_ARCHIVE_NAME STATUS------------------------------ -------FLA1SQL> alter flashback archive fla1 set default;Flashback archive altered.SQL> select FLASHBACK_ARCHIVE_NAME,status from dba_flashback_archive 2 /FLASHBACK_ARCHIVE_NAME STATUS------------------------------ -------FLA1 DEFAULT
转载于:https://www.cnblogs.com/iImax/archive/2013/04/10/oracle-flashback-archive.html