On 9/21/06, genegurevich@xxxxxxxxxxxxxxxxxxxxx < genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:
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