Oracle Create Tablespace Example

This is an example SQL Script to create an Oracle Tablespace.

DROP TABLESPACE user_data INCLUDING CONTENTS;
DROP TABLESPACE user_blob INCLUDING CONTENTS;
DROP TABLESPACE user_index INCLUDING CONTENTS;

CREATE TABLESPACE USER_DATA
   DATAFILE '/opt/oracle/product/10.2.0/oradata/sid1/user_data.dbf'
   SIZE 5M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
   EXTENT MANAGEMENT LOCAL AUTOALLOCATE
   LOGGING
   ONLINE
   SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE USER_BLOB
   DATAFILE '/opt/oracle/product/10.2.0/oradata/sid1/user_blob.dbf'
   SIZE 5M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
   EXTENT MANAGEMENT LOCAL AUTOALLOCATE
   LOGGING
   ONLINE
   SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE USER_INDEX
   DATAFILE '/opt/oracle/product/10.2.0/oradata/sid1/user_index.dbf'
   SIZE 5M AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
   EXTENT MANAGEMENT LOCAL AUTOALLOCATE
   LOGGING
   ONLINE
   SEGMENT SPACE MANAGEMENT AUTO;

CREATE TEMPORARY TABLESPACE USER_TEMP
    TEMPFILE '/opt/oracle/product/10.2.0/oradata/sid1/user_temp01.dbf'
    SIZE 50M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE unlimited
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;