手工创建数据库的全部脚本及说明2节能

--创建回滚表空间： CREATE TABLESPACE RBS DATAFILE 'D:\Oracle\oradata\test\f' SIZE 256M REUSEAUTOEXTEND ON NEXT 5120KMINIMUM EXTENT 512KDEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);

--创建用户表空间： CREATE TABLESPACE USERS DATAFILE 'D:\Oracle\oradata\test\f' SIZE 128M REUSEAUTOEXTEND ON NEXT 1280KMINIMUM EXTENT 128KDEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);

--创建临时表空间： CREATE TABLESPACE TEMP DATAFILE 'D:\Oracle\oradata\test\f' IZE 32M REUSEAUTOEXTEND ON NEXT 640KMINIMUM EXTENT 64KDEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) TEMPORARY;

--创建工具表空间： CREATE TABLESPACE TOOLS DATAFILE 'D:\Oracle\oradata\test\f' SIZE 64M REUSEAUTOEXTEND ON NEXT 320KMINIMUM EXTENT 32KDEFAULT STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);

--创建索引表空间： CREATE TABLESPACE INDX DATAFILE 'D:\Oracle\oradata\test\f' SIZE 32M REUSEAUTOEXTEND ON NEXT 1280KMINIMUM EXTENT 128KDEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);

--创建回滚段： CREATE PUBLIC ROLLBACK SEGMENT RBS0 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );CREATE PUBLIC ROLLBACK SEGMENT RBS1 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );CREATE PUBLIC ROLLBACK SEGMENT我自信自己也继承了父亲的特质。昨天有问：是否柯震东事件我贿赂了谁?当初该事件从头到尾人在北京 RBS2 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );CREATE PUB东汽独立自主完成了1MW全系列机组LIC ROLLBACK SEGMENT RBS3 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );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\l;@D:\Oracle\Ora81\Rdbms\admin\l@D:\Oracle\Ora81\Rdbms\admin\l@D:\Oracle\Ora81\Rdbms\admin\lconnect system/manager@D:\Oracle\Ora81\sqlplus\admin\lconnect internal/oracle@D:\Oracle\Ora81\Rdbms\admin\lexit

--生成SQL*Plus帮助系统： sqlplus SYSTEM/manager@D:\Oracle\Ora81\sqlplus\admin\help\l lexit

--修改system用户默认表空间和临时表空间： svrmgrlconnect internal/oraclealter user system default tablespace TOOLS;alter user system temporary tablespace TEMP;exit

7、将test实例启动服务设置成自动启动方式： D:\Oracle\Ora81\bin\oradim -edit -sid test -startmode auto。