Re: autoextend

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
  • Date: Thu, 21 Sep 2006 10:29:17 -0700

On 9/21/06, genegurevich@xxxxxxxxxxxxxxxxxxxxx <
genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:

Hi everybody:

alter database datafile FILENAME autoextend on increment XXXM maxsize
XXXM;

This will force Oracle to increase the size of the FILENAME by XXXM
(assuming that this space is available in the filesystem) whenever the
tablespace runs out
of space. It will not however affect the way the space is allocated for
the object
within my tablespace. Am I correct here?


If using LMT, the size of allocated extents is determined by tablespace
settings
eg. extent management local uniform size 1m

Autoextend applies to datafiles, not tablespaces.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: