創建大數據庫時的存儲參數詳解
2024-07-21 02:34:34
供稿：網友
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">（出處：清風軟件下載學院）
