Tablespace 실습 #3

사용자용 테이블스페이스 확장

SQL> alter database datafile '/home/oracle/oradata/testdb/insa01.dbf' resize 20m;

Database 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

6 rows selected.

SQL> alter tablespace insa
  2  add datafile '/home/oracle/oradata/testdb/insa02.dbf' size 20m;

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/testdb/insa02.dbf

7 rows selected.

SQL>