create_tablespace.sql

来自「oracle技术手册供初学者」· SQL 代码 · 共 4 行

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;