ORA-01116: error in opening database file 89
分类: DataBase 2011-02-06 17:50 118人阅读 评论(0) 收藏 举报
语法:
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 ;