Re: How to use create database?

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Tue, 1 Dec 1998 15:03:41 +0100
Message-ID: <740s7c$4rt$1@news.worldonline.nl>

Hello Kenny,
For UNIX Oracle 7 (should work for 8) :

spool createdb.log

create rollback segment Rtemp tablespace system storage (initial 16K next 16K minextents 2 ) ; alter rollback segment Rtemp online ;

rem Medium sized rollback segs
create tablespace RBS datafile
  '/local/dat02/oradata/PRNT/rbs01.dbf'

  size      200M          -- < initial size
  autoextend  ON          -- < this is where autoextent is set
  next       20M          -- < step size
  maxsize   500M          -- < Maximum growth of this file

  default storage (initial 2M next 2M ) /
create rollback segment r01 tablespace rbs

       storage (minextents 10 optimal 20M) ; create rollback segment r02 tablespace rbs

       storage (minextents 10 optimal 20M) ; create rollback segment r03 tablespace rbs

       storage (minextents 10 optimal 20M) ; create rollback segment r04 tablespace rbs

       storage (minextents 10 optimal 20M) ;

alter rollback segment R01 ONLINE ;
alter rollback segment R02 ONLINE ;
alter rollback segment R03 ONLINE ;
alter rollback segment R04 ONLINE ;

rem TEMP
rem For extsize of 2048 maximum = 2M * 121 = 242 Mb rem For extsize of 4096 maximum = 4M * 121 = 484 Mb create tablespace TEMP datafile
  '/local/dat01/oradata/PRNT/temp01.dbf' size 50M   autoextend ON next 10M
  default storage (initial 2048K next 2048K pctincrease 0 ) /

alter rollback segment Rtemp oFFline ;
drop rollback segment Rtemp ;
spool off

Kenny Leow heeft geschreven in bericht
<7408c2$909$1_at_mawar.singnet.com.sg>...
>Hi,
>
>Can anyone help me? I will like to know how to use the
>create database command. Can you kindly show me a
>sample command please.
>
>Thanks a lot.
>Kenny
Received on Tue Dec 01 1998 - 08:03:41 CST