电竞

Unix上的手工建库脚本

2019-10-17 01:50:32来源:励志吧0次阅读

在hp-ux 11i上测试通过

oracle版本为817

建好inittest.ora和PWDtest.ora

目录:

/oracle/DATA/

执行下面的脚本

set termout on

set echo on

spool test.log

connect internal

startup pfile=/oracle/product/8.1.7/dbs/inittest.ora nomount

create database test

logfile

group 1 (

'/oracle/DATA/redotest01a.log',

'/oracle/DATA/redotest01b.log' ) size 10M reuse,

group 2 (

'/oracle/DATA/redotest02a.log',

'/oracle/DATA/redotest02b.log' ) size 10M reuse,

group 3 (

'/oracle/DATA/redotest03a.log',

'/oracle/DATA/redotest03b.log' ) size 10M reuse

maxdatafiles 250

maxinstances 2

maxlogfiles 16

character set ZHS16GBK

national character set ZHS16GBK

datafile

'/oracle/DATA/systest.dbf' size 300M reuse

/

spool off

disconnect

connect internal

spool test_catalog.log

@/oracle/product/8.1.7/rdbms/admin/catalog.sql

spool off

connect internal

spool test.log

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/rbstest01.dbf' size 150M reuse,

'/oracle/DATA/rbstest02.dbf' size 150M reuse

default storage (

initial   1M

next     1M

pctincrease 0

minextents  9

maxextents  300 )

/

create tablespace temp

datafile

'/oracle/DATA/tmptest.dbf' 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_catproc.log

@/oracle/product/8.1.7/rdbms/admin/catproc.sql

spool off

spool test_catexp.log

@/oracle/product/8.1.7/rdbms/admin/catexp.sql

spool off

查看本文来源

牡丹江治疗白带异常医院
海南治疗宫颈糜烂方法
通辽白癜病医院
邢台男科医院
钦州什么医院治牛皮癣
分享到: