Ok. here is what is behind the scence:
say, you have a tablespace TS and TS has 2 datafiles (DATA1.dbf ,DATA2.dbf) with each autoextend on.
you create a table called TABLE1 on TS via:
create table TABLE1 (...) tablespace TS;
extents will be assigned from DATA1.dbf and DATA2.dbf in turn.
simply put, it will be most likely be:
extent 0 will be extracted from DATA1.dbf, extent 1 from DATA2.dbf, extent3 from DATA1.dbf ..
so:
>>Does autoextend extend within each datafile?
YES
>>When the USE(M) reaches the SIZE (M) does Oracle jump to another datafile which has more space?
as you see, it already jumps around.
>>If your using autoextend why do you have to manually add another datafile Oracle should create another datafile when needed.
you can have ONLY 1 with autoextend on.
acton
Main Topics
Browse All Topics





by: sathyagiriPosted on 2006-06-26 at 11:05:55ID: 16986328
AUTOEXTEND allows your data file to extend by the increment you specified, but can extend only upto the MAXSIZE you have specified which is (10000 M in your case).. After which you will have to add a new data file or resize your data file.
it does not automatically create a new data file if the max size is reached. For example if you created data file "A" with size 10K and autoextend with increment 10K and max size 10M. File A can grow upto size of 10M. After which you will have add a new data file.