1. 새로운 Tablespace Create

$ svrmgrl
SVRMGR> connect / as sysdba
SVRMGR> startup
SVRMGR> create tablespace test
    2  datafile '$HOME/DATA/DISK5/test_01.dbf'
    3  size 10k ;
SVRMGR> select tablespace_name, bytes, file_name from dba_data_files ;

2. Table Create 후 table 에 row들을 insert

$ sqlplus scott/tiger
SQL> create table test
  2  (name varchar2(10))
  3  storage (initial 4k)
  4  tablespace test ;
SQL> insert into test values ('TEST') ;
SQL> insert into test select * from test ;
SQL> /  <-- 아래의 error 메세지가 나올 때까지 여러번 반복한다.
ORA-01653: unable to extend table SCOTT.TEST by 5 in tablespace TEST

3. Tablespace를 늘린다.

SQL> connect system/manager
SQL> alter tablespace test add datafile '$HOME/DATA/DISK6/test02_dbf' size 30k ;
SQL> select tablespace_name, bytes, file_name from dba_data_files ;
SQL> connect scott/tiger
SQL> insert into test select * form test ;

또는 다음의 방법으로 datafile을 resize한다.
SQL> connect system/manager
SQL> alter database datafile '$HOME/DATA/DISK5/test_01.dbf' resize 50k ;
SQL> select tablespace_name, bytes, file_name from dba_data_files ;
SQL> !ls -la $HOME/DATA/DISK5
SQL> connect scott/tiger
SQL> insert into test select * from test ;
SQL> commit ;

4. 테스트가 끝나면 Drop

SQL> connect system/manager
SQL> drop tablespace test including contents ;
SQL> select tablespace_name, bytes, file_name from dba_data_files ;
SQL> !ls -la $HOME/DATA/DISK5
SQL> !ls -la $HOME/DATA/DISK6
    --> datafile이 그대로 존재한다. (reuse하기 위해서--다시 datafile을 만들때 속도가 빠르다.)
   
5. Datafile도 삭제

SQL> !rm $HOME/DATA/DISK5/test_01.dbf
SQL> !rm $HOME/DATA/DISK6/test_02.dbf
SQL> !ls -la $HOME/DATA/DISK5
SQL> !ls -la $HOME/DATA/DISK6
$ svrmgrl
SVRMGR> connect / as sysdba
SVRMGR> shutdown immediate
SVRMGR> exit