Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: autoextend

RE: autoextend

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Thu, 21 Sep 2006 09:41:36 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5B0FB@ex2.ms.polyserve.com>


 >>>It will not however affect the way the space is allocated
>>>for the object within my tablespace. Am I correct here?

yes... although you might care to test what happens if your increment value is smaller than the next extent size of a table that grows to subsequently trigger an autoextend...I think (haven't tested) that your increment value needs to be large enough to satisfy in one extending operation the size of the extent requested by the table growth... I'd test it here, but my systems are tied up.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 21 2006 - 11:41:36 CDT

Original text of this message

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