ORA-01116: error in opening database file 89
来源:互联网 发布:詹姆斯上赛季数据 编辑:程序博客网 时间:2024/05/16 09:52
语法:
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采可以删除.
现在使用:
SQL> drop tablespace osm_tabp_0 including contents
就OK了!
- ORA-01116: error in opening database file 89
- maven error in opening zip file
- android studio error in opening zip file
- maven error in opening zip file
- maven install error in opening zip file
- UNNAMED FILE ERROR IN STANDBY AFTER ADDING NEW FILE TO PRIMARY DATABASE – ORA-01111, ORA-01110, ORA-
- Error opening map file
- java.util.zip.ZipException: error in opening zip file
- java.util.zip.ZipException: error in opening zip file
- java.util.zip.ZipException: error in opening zip file
- java.util.zip.ZipException: error in opening zip file
- java.util.zip.ZipException:error in opening zip file
- Android Studio 出现error in opening zip file
- java.util.zip.ZipException: error in opening zip file
- java.util.zip.ZipException: error in opening zip file
- Android studio出现:Cause: error in opening zip file
- Gradle sync failed: Cause: error in opening zip file
- java.util.zip.ZipException: error in opening zip file
- oracle中的decode函数
- USACO 1.1 broken necklace 分析
- zoj 2770 Burn the Linked Camp
- 删除数据文件后在dba_data_files中仍旧遗留数据
- VS2005无法启动,停在启动界面,不显示IDE窗口。(VMvare的原因)
- ORA-01116: error in opening database file 89
- ORACLE 存储过程及TABLE里的数据用PL/SQL备份及用PLUS SQL还原
- Oracle DBA命令参考——alter database
- SPFile文件常用内容详解
- poj 3169 Layout
- USACO 1.4 clocks 分析
- datagrid内嵌combox
- 项目使用中Linq使用总结
- A sentence for a day