datafiles in tablespace

Hello,

i have a tablespace called abs. I noticed that tablespace has only 5 MB free, so i add another datafile to it:
alter tablespace abs add datafile '/opt/oracle/datafile2.dbf' size 500M autoextend on next 100M maxsize 1000M;

When i did it, i noticed that oracle uses new datafile, instead of old one, where there's some room (5M).
How to force oracle to still use old datafile ?

best regards

Tomec Received on Mon Jan 22 2007 - 02:13:26 CST