ORA-01110 如何删除表空间[文件已删除]

语法:
DROP TABLESPACE tablespace
   [ INCLUDING CONTENTS [ {AND | KEEP} DATAFILES ]
     [ CASCADE CONSTRAINTS ]
   ] ;

直接使用:
drop tablespace 会出现如下错误:

ORA-01116: error in opening database file 89
ORA-01110: data file 89: '/templv/osm/OSM_TABP_00.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

首先将表空间文件改为offline就可以了!

SQL>alter database datafile '/templv/osm/OSM_TABP_00.dbf' offline drop;

是每一个文件都要offline采可以删除.

现在使用:
drop tablespace osm_tabp_0 including contents
就OK了!