On 9/21/06, genegurevich_at_discoverfinancial.com <
genegurevich_at_discoverfinancial.com> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 21 2006 - 12:29:17 CDT
