Hi,
I have 3 data files associated with a tablespace with auto extend on all the datafiles. One is 512MB and others are 1024MB. I created 1GB datafiles with initial size of 512MB and with autoextend on and max of 1024MB. Now, last 2 datafiles are almost 504 MB in size and DBA tables are showing approx 512MB in total as well as used. Why it is not extending the 2 datafiles. How can I make sure that it will auto extend after 3rd one gets full.

Also, if you change auto extensible to yes after creating tablespace and having some data, does that matters.

Using oracle 8.1.7 on aix.

Aj



---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Oracle LazyDBA home page