SQL> drop tablespace fbda including contents and datafiles;
drop tablespace fbda including contents and datafiles
*
ERROR at line 1:
ORA-55641: Cannot drop tablespace used by Flashback Data Archive
测试模拟
SQL> SQL> create tablespace fbda datafile ‘+DATADG’ size 5m;
Tablespace created.
SQL> create flashback archive flar01 tablespace fbda quota 2m retention 1 year;
Flashback archive created.
SQL>
SQL>
SQL>
SQL> grant flashback archive on flar01 to dbmt;
Grant succeeded.
SQL> select table_name from dba_tables where owner=‘DBMT’;
TABLE_NAME
ITPUX01
EMP
DEPT
BONUS
SALGRADE
EMP1
6 rows selected.
SQL> alter table dbmt.EMP1 flashback archive flar01;
Table altered.
SQL>
SQL> drop tablespace fbda including contents and datafiles;
drop tablespace fbda including contents and datafiles
*
ERROR at line 1:
ORA-55641: Cannot drop tablespace used by Flashback Data Archive
SQL> drop flashback archive flar01;
Flashback archive dropped.
SQL> drop tablespace fbda including contents and datafiles;
Tablespace dropped.
SQL>
与flashback data archive有关的操作:
1.清除所有归档区的数据
SQL> alter flashback archive flar01 purge all;
2.将指定的表不再设置闪回归档
SQL> alter table test no flashback archive;
3. 将表关联至闪回归档区
SQL> alter table dbmt.emp01 flashback archive flar01;
与flashback data archive有关的视图:
*_flashback_archive 查看有哪些归档名
*_flashback_archive_ts 查看归档使用表空间的信息
*_flashback_archive_tables 查看表和归档名的关系