语法:DROP TABLESPACE tablespace [ INCLUDING CONTENTS [ {AND | KEEP} DATAFILES ][ CASCADE CONSTRAINTS ]] ;
直接使用:drop tablespace 会出现如下错误:
ORA-01116: error in opening database file 89ORA-01110: data file 89: '/templv/osm/OSM_TABP_00.dbf'ORA-27041: unable to open fileLinux Error: 2: No such file or directoryAdditional information: 3
首先将表空间文件改为offline就可以了!SQL> alter database datafile '/templv/osm/OSM_TABP_00.dbf' offline drop;
是每一个文件都要offline采可以删除.现在使用:SQL> drop tablespace osm_tabp_0 including contents就OK了!
