关于无法删除表空间的问题
有一测试库,由于是测试库,所以某人比较随便的直接在数据库关闭的状态下删除了一数据文件
现在数据中此表空间的状态是:
SQL> select file#,status,name from v$datafile where file#=3;
FILE# STATUS NAME
---------- ------- ----------------------------------------------
3 RECOVER /oracle/product/10.2.0/dbs/MISSING00003
想要把此表空间删除,然后再重新建立空的同名表空间
SQL> drop tablespace platform including contents;
drop tablespace platform including contents and datafiles
*
第 1 行出现错误:
ORA-00604: error occurred at recursive SQL level 2
ORA-00376: file 3 cannot be read at this time
ORA-01111: name for data file 3 is unknown - rename to correct file
ORA-01110: data file 3: '/oracle/product/10.2.0/dbs/MISSING00003'
ORA-06512: at line 19
请问要如何处理呢