It is acceptable to have more than datafile for SYSTEM. Technically, this adds one more point of failure : "there's a higher probability of an administrator mistakenly removing any 1 of 2 files than 1 of 1 file". Hemant K Chitale http://hemantoracledba.blogspot.com sent from my smartphone On Jan 19, 2011 3:44 PM, "Sheldon Quinny" <sheldonquinny@xxxxxxxxx> wrote: Hi Folks, I just wanted to know , having a System Tablespace with 2 Datafiles..would that overall be an good idea. Cause the only way to get it back to one datafile would be to recreate the database it self. I have done this and its works...but really , has anyone tried using this as an option or its just everyone believes system tablespace has to be on one datafile. Regards, Sheldon.