shutdown immediate startup mount alter database datafile 'datafile_name' offline drop; alter database open; drop tablespace tablespace_name;
如果数据库不能启动,采用zmgowin(隐者(龙祖宗)) 的方法先删除数据库文件在删除表空间
可是mount以后打不开啊,dbf文件已经没有了,tablespace还在,数据库也不能正常启动了SQL> shutdown immediate ORA-01109: database not open Database dismounted.ORACLE instance shut down. SQL> SQL> startup mount ORACLE instance started.Total System Global Area 303530016 bytes Fixed Size 741408 bytes Variable Size 268435456 bytes Database Buffers 33554432 bytes Redo Buffers 798720 bytes Database mounted. SQL> alter database open 2 ; alter database open * ERROR at line 1: ORA-01157: cannot identify/lock data file 10 - see DBWR trace file ORA-01110: data file 10: '/data/dbf/db01.dbf'
startup mount
alter database datafile 'datafile_name' offline drop;
alter database open;
drop tablespace tablespace_name;
ORA-01109: database not open
Database dismounted.ORACLE instance shut down.
SQL> SQL> startup mount
ORACLE instance started.Total System Global Area 303530016 bytes
Fixed Size 741408 bytes
Variable Size 268435456 bytes
Database Buffers 33554432 bytes
Redo Buffers 798720 bytes
Database mounted.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/data/dbf/db01.dbf'