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 -> Re: Algorithm for calculating extent size in LMT

Re: Algorithm for calculating extent size in LMT

From: Emil Przychodzen <emil.przychodzen_at_intrum.pl>
Date: Tue, 5 Mar 2002 09:52:25 +0100
Message-ID: <a620vj$qor$1@news.tpi.pl> 





> >LMTS Dont use the Initial Next and MinExtents they are ignored when a

>> TBS is declared as a LMT.



> Absolutley Wrong ... See above !!!




Have you read the Oracle manual - the chapter regarding LMT ???
Quotation - 'When an object is created in a locally managed tablespace,
Oracle uses its INITIAL, NEXT, and MINEXTENTS parameters to calculate the
initial size of the object's segment'. So the parameters such as INITIAL,
NEXT, MINEXTENTS of an *object* are important here...



Regards


EP
Received on Tue Mar 05 2002 - 02:52:25 CST












Original text of this message













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