ORA-55641: Cannot drop tablespace used by Flashback Data Archive

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 查看表和归档名的关系