about segment setting

From: wqhdebian <wqhdebian_at_263.net>
Date: 8 Jul 2002 18:26:51 -0700
Message-ID: <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 - 03:26:51 CEST

Original text of this message