create_tablespace.sql

一本介绍oracle的书籍

create tablespace ts_default default storage(initial 128k next 128k maxextents unlimited pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_default.dbf' size 50M;
create tablespace ts_data default storage(initial 10M next 10M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_data.dbf' size 800M;
create tablespace ts_index default storage(initial 5M next 5M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_index.dbf' size 500M;