Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create dB and initial rollback segs

Create dB and initial rollback segs

From: Frank Siegel <NorthernSnow_at_worldnet.att.net>
Date: Mon, 16 Aug 1999 11:54:55 -0400
Message-ID: <7p9cic$r06$1@bgtnsc02.worldnet.att.net>


When the create dB statement is issued, is there automtically a SYSTEM rbs in the datafile '/u01/app/oradata/DW1/system.dbf' (see below create dB)?

Is the next step to create a 2nd rbs in the SYSTEM t/s? Why the system tablespace?
Why don't I just create subsequent T/S's for the new additional rbs's at this time rather
than putting the new rbs in the system tablespace?

Would the next step be to create more tablespaces for more rbs's? (We want to use 10 rbs all together)

Thanks
Frank S.

CREATE database "DW1" maxinstances 1 maxlogfiles 16 character set "US7ASCII"
datafile
  '/u01/app/oradata/DW1/system.dbf' size 262144000 reuse logfile

  group 1 ('/u01/app/oradata/DW1/redo01a.log',

'/u02/app/oradata/DW1/redo01b.log') size 262144000,
group 2 ('/u01/app/oradata/DW1/redo02a.log',
'/u02/app/oradata/DW1/redo02b.log') size 262144000,
group 3 ('/u01/app/oradata/DW1/redo03a.log', /u02/app/oradata/DW1/redo03b.log) size 262144000, group 4 ('/u01/app/oradata/DW1/redo04a.log',
'/u02/app/oradata/DW1/redo04b.log') size 262144000;
Received on Mon Aug 16 1999 - 10:54:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US