다음과 같은 Error가 난다.

SVRMGR> STARTUP;
ORACLE instance started
Database mounted
ORA-01157 : cannot identify data file 11 - file not found
ORA-01110 : data file 11 : '/user1/oracle8/dbs/user1.dbf'
Attempting to dismount database .... Database dismounted
Attempting to shutdown instance .... ORACLE instance shut down


여기서의 해결방법은 Datafile을 Drop하고 Tablespace도 Drop을 하는 예이다.

$ svrmgrl
SVRMGR> CONNECT INTERNAL;
SVRMGR> STARTUP MOUNT;
ORACLE instance started.
Database mounted.

SVRMGR> ALTER DATABASE DATAFILE '/user1/oracle8/dbs/user1.dbf'
OFFLINE DROP;
Statement processed.

SVRMGR> ALTER DATABASE OPEN;
Statement processed.

SVRMGR> DROP TABLESPACE tablespace_name INCLUDING CONTENTS;
Statement processed.