手工创建Oracle数据库脚本及说明

　2007-05-09 12:12:14　来源：WEB开发网　　　

核心提示： --使回滚段在线ALTER ROLLBACK SEGMENT "RBS0" ONLINE;ALTER ROLLBACK SEGMENT "RBS1" ONLINE;ALTER ROLLBACK SEGMENT "RBS2" ONL

--使回滚段在线

ALTER ROLLBACK SEGMENT "RBS0" ONLINE;
ALTER ROLLBACK SEGMENT "RBS1" ONLINE;
ALTER ROLLBACK SEGMENT "RBS2" ONLINE;
ALTER ROLLBACK SEGMENT "RBS3" ONLINE;
ALTER ROLLBACK SEGMENT "RBS4" ONLINE;
ALTER ROLLBACK SEGMENT "RBS5" ONLINE;
ALTER ROLLBACK SEGMENT "RBS6" ONLINE;
ALTER ROLLBACK SEGMENT "RBS7" ONLINE;
ALTER ROLLBACK SEGMENT "RBS8" ONLINE;
ALTER ROLLBACK SEGMENT "RBS9" ONLINE;
ALTER ROLLBACK SEGMENT "RBS10" ONLINE;
ALTER ROLLBACK SEGMENT "RBS11" ONLINE;
ALTER ROLLBACK SEGMENT "RBS12" ONLINE;
ALTER ROLLBACK SEGMENT "RBS13" ONLINE;
ALTER ROLLBACK SEGMENT "RBS14" ONLINE;
ALTER ROLLBACK SEGMENT "RBS15" ONLINE;
ALTER ROLLBACK SEGMENT "RBS16" ONLINE;
ALTER ROLLBACK SEGMENT "RBS17" ONLINE;
ALTER ROLLBACK SEGMENT "RBS18" ONLINE;
ALTER ROLLBACK SEGMENT "RBS19" ONLINE;
ALTER ROLLBACK SEGMENT "RBS20" ONLINE;
ALTER ROLLBACK SEGMENT "RBS21" ONLINE;
ALTER ROLLBACK SEGMENT "RBS22" ONLINE;
ALTER ROLLBACK SEGMENT "RBS23" ONLINE;
ALTER ROLLBACK SEGMENT "RBS24" ONLINE;

--修改sys用户的临时表空间为TEMP

alter user sys temporary tablespace TEMP;

--创建数据字典表

@D:OracleOra81Rdbmsadmincatalog.sql;
@D:OracleOra81Rdbmsadmincatexp7.sql
@D:OracleOra81Rdbmsadmincatproc.sql
@D:OracleOra81Rdbmsadmincaths.sql
connect system/manager
@D:OracleOra81sqlplusadminpupbld.sql
connect internal/oracle
@D:OracleOra81Rdbmsadmincatrep.sql
exit

--生成SQL*Plus帮助系统

sqlplus SYSTEM/manager

@D:OracleOra81sqlplusadminhelphelpbld.sql helpus.sql

exit

--修改system用户默认表空间和临时表空间

svrmgrl

connect internal/oracle

alter user system default tablespace TOOLS;

alter user system temporary tablespace TEMP;

exit

7、将test实例启动服务设置成自动启动方式

D:OracleOra81inoradim -edit -sid test -startmode auto