That's odd because I am using 9207 on RH and that uses the single datafile. PS Norman, Did you have the unfortunate experience of working with Mr Maufe at the EA in Leeds. I know him well John -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Norman Dunbar Sent: 20 October 2005 12:09 To: niall.litchfield@xxxxxxxxx Cc: ORACLE-L@xxxxxxxxxxxxx Subject: Re: DATAFILE?? >>> Niall Litchfield <niall.litchfield@xxxxxxxxx> 10/20/05 11:29am >>> On 10/18/05, oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> wrote: >> Unfortunately, if you run the test you'll find that your assertion isn't >> correct on 10gR1 :) Confirmed on 9204 as well. It seems to do a round robin of all the datafiles. Cheers, Norman. -- //www.freelists.org/webpage/oracle-l