手工创建oracle数据库
CREATE PUBLIC ROLLBACK SEGMENT RBS4 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS5 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS6 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS7 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS8 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS9 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS10 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS11 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS12 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS13 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS14 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS15 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS16 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS17 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS18 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS19 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS20 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS21 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS22 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS23 TABLESPACE RBS STORAGE ( OPTIMAL 4096K ); CREATE PUBLIC ROLLBACK SEGMENT RBS24 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
--使回滚段在线 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:\Oracle\Ora81\Rdbms\admin\catalog.sql; @D:\Oracle\Ora81\Rdbms\admin\catexp7.sql @D:\Oracle\Ora81\Rdbms\admin\catproc.sql @D:\Oracle\Ora81\Rdbms\admin\caths.sql
connect system/manager @D:\Oracle\Ora81\sqlplus\admin\pupbld.sql
connect internal/oracle @D:\Oracle\Ora81\Rdbms\admin\catrep.sql exit
--生成SQL*Plus帮助系统 sqlplus SYSTEM/manager |