*** datafile이 지워졌을때 ***

SVRMGR> connect internal
Connected.

SVRMGR> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SVRMGR> startup mount
ORACLE instance started.
Total System Global Area      17970260 bytes
Fixed Size                      39808 bytes
Variable Size                11368660 bytes
Database Buffers              6553600 bytes
Redo Buffers                      8192 bytes
Database mounted.


SVRMGR> alter database datafile '/home6/edu/young2/youngtablespc.dbf' offline drop;
Statement processed.

SVRMGR> alter database open;
Statement processed.

SVRMGR> select * from user_tablespaces;
TABLESPACE_NAME                INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA STATUS    CONTENTS
------------------------------ ---------- ---------- ---------- ---------- ---------- --------- ---------
SYSTEM                              10240      10240          1        121        50 ONLINE    PERMANENT
RBS                                131072    131072          2        121          0 ONLINE    PERMANENT
TEMP                              1048576    1048576          1        121          0 ONLINE    PERMANENT
:
:
13 rows selected.


SVRMGR> drop tablespace young INCLUDING CONTENTS;
Statement processed.

SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

SVRMGR> startup
ORACLE instance started.
Total System Global Area      17970260 bytes
Fixed Size                      39808 bytes
Variable Size                11368660 bytes
Database Buffers              6553600 bytes
Redo Buffers                      8192 bytes
Database mounted.
Database opened.