数据库无法打开

[oracle@js-oracle oracle]$ sqlplus /NOLOG

SQL> connect sys/wellhope as sysdba

SQL> alter database datafile /'/home/oracle/ora/products/9.2.0/oradata/ora9i/tablespace_ecms.dbf/' offline drop;

SQL> alter database open; --则数据库正常打开

SQL> select file#,name,status from v$datafile;

SQL> drop tablespace tablespace_ecms INCLUDing contents;

表空间已丢弃。

 

程序员特区

http://coderarea.net/html/shujukukaifa/Oracle/2009/0311/60196.html