Ora-01116

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 ;