datafile이 지워졌을 때
작성자 관리자 작성시간 2003-02-27 12:07:59
 

*** 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.


목록 | 입력 | 수정 | 답변 | 삭제