-- create tablespace

-- Examples:
-- Windows
CREATE TABLESPACE DBSTAR 
   DATAFILE 'E:\ORADATA\DBSTAR\DBSTAR_DBSTAR.DBF' SIZE 20M autoextend on next 20M maxsize 1000M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
;


-- unix
CREATE TABLESPACE DBSTAR 
   DATAFILE '/db03/oradata/DBSTAR/DBSTAR_DBSTAR' SIZE 500M autoextend on next 100M maxsize 1500M
DEFAULT STORAGE (INITIAL  2M NEXT  1M
                 MINEXTENTS 1 MAXEXTENTS 2147483645
                 PCTINCREASE 1)
ONLINE
;

CREATE TABLESPACE TESTITX
   DATAFILE '/db13/oradata/DBSTAR/DBSTAR_TESTITX' SIZE 200M autoextend on next 100M maxsize 6000M
DEFAULT STORAGE (INITIAL  1M NEXT  5M
                 MINEXTENTS 1 MAXEXTENTS 2147483645
                 PCTINCREASE 1)
;


CREATE TABLESPACE DBSTAR_LARGE_IDX 
   DATAFILE '/db14/oradata/DBSTAR/DBSTAR_DBSTAR_large_idx01.dbf' SIZE 500M autoextend on next 100M maxsize 1000M
DEFAULT STORAGE (INITIAL  1M NEXT  1M
                 MINEXTENTS 1 MAXEXTENTS unlimited
                 PCTINCREASE 1)
;