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 -> rollback segment initial size

rollback segment initial size

From: Daud <daud11_at_hotmail.com>
Date: 18 Sep 2002 02:49:51 -0700
Message-ID: <f0bf3cc3.0209180149.1a042628@posting.google.com>


I created a LMT tablespace with uniform extent 512K for rollback segments.
I then created a rollback segment.

create rollback segment rb01 tablespace RBS storage (initial 512K next 512K minextents 6)
/

Ok...when I checked it has 6 extents.
However, minextents is 1 and initial is set to 512*6 K. Why is that? Why not minextents = 6 and initial = 512K like what I said it should be when I created it?

rgds
Daud Received on Wed Sep 18 2002 - 04:49:51 CDT

Original text of this message

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