误删除表空间物理数据后,直接drop掉:
sqlplus: conn / as sysdba;
SQL>SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> alter database open;
SQL>alter database datafile '/oracle/product/11.2.0/db_1/dbs/test' offline drop;--test为表空间test.dbf文件
SQL>drop tablespace test including contents and datafiles;--删除表空间test
SQL>SHUTDOWN IMMEDIATE;
SQL> STARTUP;