SQL> drop tablespace FLASHBACK_DATA_ARCHVIE including contents and datafiles; drop tablespace FLASHBACK_DATA_ARCHVIE including contents and datafiles * ERROR at line 1: ORA-55641: Cannot drop tablespace used by Flashback Data Archive
this is because this tablespace is using for flashback data archive, for identify name of flashback data archive we can query:
select flashback_archive_name, status from dba_flashback_archive; FLASHBACK_ARCHIVE_NAME STATUS ------------------------------ ------- ANDO fdba1
drop fdba1
SQL> drop flashback archive fdba1; Flashback archive dropped.
after that we can drop tablespace
SQL> drop tablespace FLASHBACK_DATA_ARCHVIE including contents and datafiles; Tablespace dropped.