Program
-------
spool des65largeTBS.log
prompt Creating tablespaces for large 6i Repository...
prompt
prompt tablespace CONSTANT_GROW_INDEXES
create tablespace CONSTANT_GROW_INDEXES
datafile 'E:\ORADB\ORADATA\ORA8I\CONSTANT_GROW_INDEXES.dbf'
size 2400k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace CONSTANT_GROW_TABLES
create tablespace CONSTANT_GROW_TABLES
datafile 'E:\ORADB\ORADATA\ORA8I\CONSTANT_GROW_TABLES.dbf'
size 9000k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace DEPENDENCY_INDEXES
create tablespace DEPENDENCY_INDEXES
datafile 'E:\ORADB\ORADATA\ORA8I\DEPENDENCY_INDEXES.dbf'
size 3600k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace DEPENDENCY_TABLES
create tablespace DEPENDENCY_TABLES
datafile 'E:\ORADB\ORADATA\ORA8I\DEPENDENCY_TABLES.dbf'
size 4800k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace DIAGRAM_INDEXES
create tablespace DIAGRAM_INDEXES
datafile 'E:\ORADB\ORADATA\ORA8I\DIAGRAM_INDEXES.dbf'
size 840k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace DIAGRAM_TABLES
create tablespace DIAGRAM_TABLES
datafile 'E:\ORADB\ORADATA\ORA8I\DIAGRAM_TABLES.dbf'
size 1320k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace LOB_DATA
create tablespace LOB_DATA
datafile 'E:\ORADB\ORADATA\ORA8I\LOB_DATA.dbf'
size 700k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace RAPID_GROW_INDEXES
create tablespace RAPID_GROW_INDEXES
datafile 'E:\ORADB\ORADATA\ORA8I\RAPID_GROW_INDEXES.dbf'
size 180000k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace RAPID_GROW_TABLES
create tablespace RAPID_GROW_TABLES
datafile 'E:\ORADB\ORADATA\ORA8I\RAPID_GROW_TABLES.dbf'
size 231500k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace SYSTEM_META_INDEXES
create tablespace SYSTEM_META_INDEXES
datafile 'E:\ORADB\ORADATA\ORA8I\SYSTEM_META_INDEXES.dbf'
size 13200k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace SYSTEM_META_TABLES
create tablespace SYSTEM_META_TABLES
datafile 'E:\ORADB\ORADATA\ORA8I\SYSTEM_META_TABLES.dbf'
size 20400k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace TEMPORARY_INDEXES
create tablespace TEMPORARY_INDEXES
datafile 'E:\ORADB\ORADATA\ORA8I\TEMPORARY_INDEXES.dbf'
size 3600k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace TEMPORARY_TABLES
create tablespace TEMPORARY_TABLES
datafile 'E:\ORADB\ORADATA\ORA8I\TEMPORARY_TABLES.dbf'
size 6000k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace VERSION_INDEXES
create tablespace VERSION_INDEXES
datafile 'E:\ORADB\ORADATA\ORA8I\VERSION_INDEXES.dbf'
size 5400k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace VERSION_TABLES
create tablespace VERSION_TABLES
datafile 'E:\ORADB\ORADATA\ORA8I\VERSION_TABLES.dbf'
size 9720k
default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
/
prompt tablespace DES6I_TEMP
create tablespace DES6I_TEMP
datafile 'E:\ORADB\ORADATA\ORA8I\DES6I_TEMP.dbf'
size 4500k
temporary
/
spool off
.
right"(出处:清风软件下载学院)