误删除表空间物理数据后,直接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;
