create_tablespace.sql

来自「oracle常用脚本」· SQL 代码 · 共 15 行

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;

create tablespace ts_data1 default storage(initial 10M next 10M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_data1.dbf' size 100M;
create tablespace ts_data2 default storage(initial 10M next 10M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_data2.dbf' size 100M;
create tablespace ts_data3 default storage(initial 10M next 10M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_data3.dbf' size 100M;
create tablespace ts_data4 default storage(initial 10M next 10M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_data4.dbf' size 100M;
create tablespace ts_data5 default storage(initial 10M next 10M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_data5.dbf' size 100M;
create tablespace ts_index1 default storage(initial 5M next 5M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_index1.dbf' size 100M;
create tablespace ts_index2 default storage(initial 5M next 5M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_index2.dbf' size 50M;
create tablespace ts_index3 default storage(initial 5M next 5M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_index3.dbf' size 50M;
create tablespace ts_index4 default storage(initial 5M next 5M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_index4.dbf' size 50M;
create tablespace ts_index5 default storage(initial 5M next 5M maxextents 5000 pctincrease 0) datafile '/opt/oracle/oradata/oradb/ts_index5.dbf' size 50M;