Originally posted by a128
Hi,

If I have a tablespace containing two datafiles: data1.dbf, data2.dbf, how can I ensure both files grow evenly when new tables are created and data are inserted?

If I started out with only one datafile: data1.dbf and later decided to spread out the data to newly created data2.dbf, how do I ensure that?

Thanks,
The extents are allocated to multiple datafiles for a tablespace in a round-robin fashion. So at some point all files are almost equally large.