删除表空间报ORA-55641

删除测试表空间报错

[oracle@rac01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 7 15:47:11 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
test
test_TEMP

7 rows selected.

SQL> drop tablespace test including contents and datafiles;
drop tablespace test including contents and datafiles
*
ERROR at line 1:
ORA-55641: Cannot drop tablespace used by Flashback Data Archive

SQL> !oerr ora 55641
55641, 00000, "Cannot drop tablespace used by Flashback Data Archive"
// *Cause: An attempt was made to drop a Flashback Data Archive tablespace.
// *Action: Remove the tablespace from Flashback Data Archive before retrying the operation.
//

查看闪回设置

SQL> select flashback_archive_name name, status  from dba_flashback_archive;

NAME			       STATUS
------------------------------ -------
FDA1

测试使用可以删除

SQL> drop flashback archive FDA1;

Flashback archive dropped.

SQL> select flashback_archive_name name, status  from dba_flashback_archive;

NAME			       STATUS
------------------------------ -------
FDA1

SQL> drop tablespace test including contents and datafiles;
drop tablespace test including contents and datafiles
*
ERROR at line 1:
ORA-55641: Cannot drop tablespace used by Flashback Data Archive


SQL> SELECT table_name,archive_table_name,status from dba_flashback_archive_tables;
SQL> col table_name for a30
SQL> /

TABLE_NAME		       ARCHIVE_TABLE_NAME				     STATUS
------------------------------ ----------------------------------------------------- -------------
TEMP_XSSR		       SYS_FBA_HIST_73339				     DISABLED


SQL> drop table test.TEMP_XSSR;

Table dropped.

SQL> SELECT table_name,archive_table_name,status from dba_flashback_archive_tables;

no rows selected

SQL> drop tablespace test including contents and datafiles;

Tablespace dropped.