我已创建此表空间
CREATE TABLESPACE IA643_TBS
DATAFILE 'IA643_dat' SIZE 500K
AUTOEXTEND ON NEXT 300K MAXSIZE 100M;
我尝试使用这个命令删除它
DROP TABLESPACE IA643_TBS;
它说它已被删除,当我试图重新创建它时,我收到了以下错误消息:
ERROR at line 1:
ORA-01119: error in creating database file 'IA643_dat'
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists
我该如何删除数据文件并重新创建与原文件名相同的表空间?