Re: about segment setting

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 09 Jul 2002 03:33:26 GMT
Message-ID: <aQsW8.285600$R61.156713_at_rwcrnsc52.ops.asp.att.net>


No, but close. What it is saying is that create at least 3 extents and each extent is 100K. As it needs more it will create them in 100K increments. Jim
"wqhdebian" <wqhdebian_at_263.net> wrote in message news:db288b61.0207081726.587304e8_at_posting.google.com...
> I encounter a problem when read the content of segment setting:
>
>
> CREATE PUBLIC ROLLBACK SEGMENT rbseg_11
> TABLESPACE rbseg
> STORAGE(
> INITIAL 100K
> NEXT 100K
> MINEXTENTS 3
> MAXEXTENTS 100
> OPTIMAL 310K
> )
> Is that means When the segment if not sufficient to store the data
> ,then it will increase storage space about 300K(the MINEXTENTS =3,so
> the first increasment is 3*100=300),but if it lack storage space
> again,it just increase space about 100K,
> thanks
Received on Tue Jul 09 2002 - 05:33:26 CEST

Original text of this message