Tablespace 실습 #4

OPEN 상태에서 Data file 이동

SQL> alter tablespace insa offline;

Tablespace altered.

SQL> !mv /home/oracle/oradata/testdb/insa02.dbf /home/oracle/oradata/

SQL> alter tablespace insa rename
  2  datafile '/home/oracle/oradata/testdb/insa02.dbf'
  3  to '/home/oracle/oradata/insa02.dbf';

Tablespace altered.

SQL> alter tablespace insa online;

Tablespace altered.

SQL> select tablespace_name, bytes, file_name from dba_data_files;

TABLESPACE_NAME       BYTES FILE_NAME
---------------- ---------- --------------------------------------------------
USERS               5242880 /home/oracle/oradata/testdb/users01.dbf
SYSAUX            251658240 /home/oracle/oradata/testdb/sysaux01.dbf
UNDOTBS1           36700160 /home/oracle/oradata/testdb/undotbs01.dbf
SYSTEM            503316480 /home/oracle/oradata/testdb/system01.dbf
EXAMPLE           104857600 /home/oracle/oradata/testdb/example01.dbf
INSA               20971520 /home/oracle/oradata/testdb/insa01.dbf
INSA               20971520 /home/oracle/oradata/insa02.dbf

7 rows selected.

SQL>