创建表空间

设置表空间:
create tablespace GXGASC   
datafile 'G:/oracleTablespace/GXGASC.dbf'   
size 1500M   
autoextend on next 1024M maxsize 3000M; 
alter user gxgasc default tablespace GXGASC;

create tablespace GSC  
datafile 'G:/oracleTablespace/GSC.dbf'   
size 31000M   
autoextend on next 10240M; 
alter user gsc default tablespace GSC;

create tablespace GSCRESULT  
datafile 'G:/oracleTablespace/GSCRESULT.dbf'   
size 31000M   
autoextend on next 10240M; 
alter user gscresult default tablespace GSCRESULT;