Re: datafiles in tablespace

tomec_at_obywatel.pl wrote:
> 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
>

Oracle will use the datafiles in round-robin fashion. The next extent would be allocated in the second datafile. Then the next one would be allocated in the first datafile. And so on...

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown