grjohnson,

> and then another when it's required.

You basically point out my question: when is it required? If I set it to grow "unlimited", am I pretty safe?

I currently have only one file for the tablespace. However, it now grows to 6GB and I'd like to have the second datafile. Honestly, I am not sure if it's necessary because I have 0+1 RAID. I am just curious how Oracle and what settings determine which table/data goes to which datafile, if I don't explicitly speicify it?

Is it still preferred to have several datafiles for a single tablespace even if it's 0+1?

Thanks,