unix上的手工建库脚本

2024-07-21 02:40:26

字体：大中小

来源：转载

供稿：网友

在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

测试通过：）

上一篇：归档问题

下一篇：[技术]浅谈字符集问题