How to create tablespace in oracle

There are some types of tablespace in oracle. This post will discuss about how to create tablespace in oracle using syntax.

1. Permanent Tablespace
   
   create tablespace ts_test
   logging
   datafile '/datafiles/ts_test.dbf'
   size 32m
   autoextend on
   next 32m maxsize 2048m
   extent management local;
2. Temporary Tablespace
   
   create temporary tablespace temp_test
   tempfile '/datafiles/temp_test.dbf'
   size 32m
   autoextend on
   next 32m maxsize 2048m
   extent management local;
3. Undo Tablespace
   
   create undo tablespace ts_undo
   datafile '/datafiles/undo.dbf'
   size 100M;
4. More than one datafile
   
   create tablespace ts_test
   datafile '/datafiles/test_01.dbf' size 4M autoextend off,
   '/datafiles/test_02.dbf' size 4M autoextend off,
   '/datafiles/test_03.dbf' size 4M autoextend off
   logging
   extent management local;