比高版本简单
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/936/viewspace-60522/,如需转载,请注明出处,否则将追究法律责任。