??ORACLE?????????????

??????ORACLE???????????????ORACLE?????????????

????--ORACLE????????????????????????????????????????????ɡ?

????--??????????仯?????????????????I/O???????????

????--???????????????????????

????--??????LUNIX?????????????????????????????????????

?????.????????????

????-- ??????ALTER DATABASE??ALTER TABLESPACE???????????????????

????1. ALTER DATABASE??????

????-- ????????????????κα?????????????

STEP 1. ???????
$ sqlplus /nolog
SQL> CONNECT INTERNAL;
SQL> SHUTDOWN;
SQL> EXIT;
STEP 2.?ò?????????????????????
-- ????????? 'test.ora' ??/ora/oracle/data1???????/ora/oracle/data2???￡?
$ mv /ora/oracle/data1/test.ora /ora/oracle/data2
STEP 3. Mount???????ALTER DATABASE?????????????????
$ sqlplus /nolog
SQL> CONNECT INTERNAL;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RENAME FILE '/ora/oracle/data1/test.ora' TO '/ora/oracle/data2/test.ora';
STEP 4. ???????.
SQL> ALTER DATABASE OPEN;
SQL>SELECT NAME??STATUS FROM V$DATAFILE??

????2. ALTER TABLESPACE??????

????-- ??????????????????????????SYSTEM??????????????ACTIVE????λ?????ε????

STEP1. ???????????????????OFFLINE??
$ sqlplus /nolog
SQL> CONNECT INTERNAL;
SQL> ALTER TABLESPACE test OFFLINE;
SQL> EXIT;
STEP2. ?ò?????????????????????
????????? 'test.ora' ??/ora/oracle/
data1???????/ora/oracle/data2???￡?
$ mv /ora/oracle/data1/test.ora /ora/oracle/data2
STEP3. ??ALTER TABLESPACE????????????????
$ sqlplus /nolog
SQL> CONNECT INTERNAL;
SQL> ALTER TABLESPACE test RENAME DATAFILE '/ora/oracle/data1/test.ora' TO '/ora/oracle/data2/test.ora';
STEP4. ???????????????????ONLINE??
SQL> ALTER TABLESPACE test ONLINE;
SQL> SELECT NAME??STATUS FROM V$DATAFILE??