-- * Create tablespaces for XC_DATA.
-- *

SET ECHO ON
SPOOL XCTableSpaces.OUT

CREATE TABLESPACE XC_DATA 
  DATAFILE 'D:\ORACLE\ORADATA\SPSERVER\XC_DATA.DBF' SIZE 100M AUTOEXTEND ON NEXT 1M
  DEFAULT STORAGE (
    INITIAL     256K
    NEXT        256K
    MAXEXTENTS  UNLIMITED
    PCTINCREASE 0
);


CREATE TEMPORARY TABLESPACE XC_TEMP 
    TEMPFILE 'D:\ORACLE\ORADATA\SPSERVER\XC_TEMP.dbf' SIZE 20M AUTOEXTEND 
    ON NEXT 1M MAXSIZE UNLIMITED;
    
SPOOL OFF
