Re: Just a General Question on System Tablespace.
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: sheldonquinny@xxxxxxxxx
- Date: Wed, 19 Jan 2011 23:52:13 +0800
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.
Other related posts:
