Re: about segment setting
Date: 9 Jul 2002 08:57:27 -0700
Message-ID: <ecf365d5.0207090757.422ec2b1_at_posting.google.com>
Yes It creates the first extent 3*100k and then the next extents will
be each 100k each.The default of minextent is 1 so it will create 100k
if you did not mention minextents.
You got it all figured out
Michael Tubuo Ngong
wqhdebian_at_263.net (wqhdebian) 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 - 17:57:27 CEST