this is a extra element for clear the floated element
创建大数据库时的存储参数详解
  • 12/31
  • 2008
PLSQL | Oracle 1175 次查看
  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

  .

  
您可能感兴趣的:

更多相关内容