oracle7的一个建库过程

比高版本简单
   connect internal;
   startup nomount;
   CREATE DATABASE CCPROD1
   LOGFILE
   GROUP 1 ('/user5/oradata/CCPROD1/log11.log') SIZE 100000K,
   GROUP 2 ('/user5/oradata/CCPROD1/log21.log') SIZE 100000K,
   GROUP 3 ('/user5/oradata/CCPROD1/log31.log') SIZE 100000K,
   GROUP 4 ('/user5/oradata/CCPROD1/log41.log') SIZE 100000K,
   GROUP 5 ('/user5/oradata/CCPROD1/log51.log') SIZE 100000K
   MAXLOGFILES 20
   MAXDATAFILES 254
   NOARCHIVELOG
   EXCLUSIVE
   CHARACTER SET ZHT16BIG5
   DATAFILE
   '/user5/oradata/CCPROD1/system.dbf' size 1024m ;
 2运行相应的建库包
   connect internal;
   @/user0/oracle1/rdbms/admin/catalog.sql
  
   connect internal;
   @/user0/oracle1/rdbms/admin/catproc.sql
 3 建立回滚段表空间和回滚段
   connect internal;
   create tablespace rbs datafile '/user5/oradata/CCPROD1/rbs.dbf' size 1500M ;
   create rollback segment rb0 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
   create rollback segment rb1 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
   create rollback segment rb2 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
   create rollback segment rb3 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
   create rollback segment rb5 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
   create rollback segment rb6 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
   create rollback segment rb7 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
   create rollback segment rb8 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
   create rollback segment rb9 storage(initial 100K next 100K minextents 10 maxextents 2000 optimal 40m) tablespace rbs;
  4 运行建库包
  connect system/manager;
  @/user0/oracle1/sqlplus/admin/pupbld.sql
  5 修改参数文件
  编辑 initCCPROD1.ora 加入rbs_segment 
请使用浏览器的分享功能分享到微信等