上的手工建库脚本覆盖

在hp-ux 11i上测试通过

oracle版本为817

建好a和a

目录：

/oracle/DATA/

执行下面的脚本

set termout on

set echo on

spool g

connect internal

startup pfile=/oracle/product/8.1.7/dbs/a nomount

create database　test

logfile

group 1 (

\'/oracle/DATA/g\',

\'/oracle/DATA/g\' ) size 10M reuse,

group 2 (

\'/oracle/DATA/g\',

\'/oracle/DATA/g\' ) size 10M reuse,

group 3 (

\'/oracle/DATA/g\',

\'/oracle/DATA/g\' ) size 10M reuse

maxdatafiles 250

maxinstances 2

maxlogfiles 16

character set ZHS16GBK

national character set ZHS16GBK

datafile

\'/oracle/DATA/f\' size 300M reuse

/

spool off

disconnect

connect internal

spool test_g

@/oracle/product/8.1.7/rdbms/admin/l

spool off

connect internal

spool g

create rollback segment r0 tablespace system

storage (

initial　　 32k

next　　　　32k

minextents　2

大货车高速上起火 一车烟花爆竹被引燃(图) maxextents　100　)

/

alter rollback segment r0 online

/

create tablespace rbs

datafile

\'/oracle/DATA/f\' size 150M reuse,

\'/oracle/DATA/f\' size 150M reuse

default storage (

initial　　　1M

next　　　　 1M

pctincrease　0

minextents　 9

maxextents　 300　)

/

create tablespace temp

datafile

\'/oracle/DATA/f\' size 500M reuse

default storage (

initial　　　128k

next　　　　 128k

pctincrease　0 )

temporary

/

create rollback segment r01 tablespace rbs

storage ( optimal 20M )

/

create rollback segment r02 tablespace rbs

storage ( optimal 20M )

/

create rollback segment r03 tablespace rbs

storage ( optimal 20M )

/

create rollback segment r04 tablespace rbs

storage ( optimal 20M )

/

create ??????rollback segment r05 tablespace rbs

storage ( optimal 20M )

/

create rollback segment r06 tablespace rbs

storage ( optimal 20M )

/

create rollback segment r07 tablespace rbs

storage ( optimal 20M )

/

create rollback segment r08 tablespace rbs

storage ( optimal 20M )

/

alter rollback segment r01 online

/

alter rollback segment r02 online

/

alter rollback segment r03 online

/

alter rollback segment r04 online

/

alter rollback segment r05 online

/

alter rollback segment r06 online

/

alter rollback segment r07 online

/

alter rollback segment r08 online

/

alter rollback segment r0　offline

/

alter user system temporary tablespace temp

/

spool off

connect internal

spool test_g

@/oracle/product/8.1.7/rdbms/admin/l

spool off

spool test_g

@/oracle/product/8.1.7/rdbms/admin/l

spool off

查看本文来源

孩子消化不良吃什么好
宝鸡白癜风哪里治疗好
天津治疗早泄哪家好