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
- References:
- autoextend
- From: genegurevich
Other related posts:
- » autoextend
- » RE: autoextend
- » Re: autoextend
- » RE: autoextend
- » Re: autoextend
- » Re: autoextend
- » RE: autoextend
- » RE: autoextend
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?
- autoextend
- From: genegurevich