RE: Rule of thumb for new schema vs. new database?

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Wed, 5 Oct 2005 16:17:35 -0500
Message-ID: <683E0A1C82D75246BD9F4E01F77CBB0F01A0DB42@pscdalpexch02.perotsystems.net>

New schema is preferable UNLESS you know for sure that the two applications cannot cohabitate the same database due to their individual characteristics....

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BP Sent: Wednesday, October 05, 2005 4:09 PM To: Oracle-L
Subject: Rule of thumb for new schema vs. new database?

Hi Again,

I have a meeting tomorrow with one of our project managers who is going to request a new schema or database. He wants my advice on which is best for his needs. Now...as I've said before I'm a neophyte DBA and do know the difference between a schema and a new database. I'm inclined to suggest just a new schema, but now I'm wondering to myself what kind of 'rule of thumb' is there is for this kind of decision.

When would it be preferable to create a new db vs. just a schema in an existing db?

Thanks for you help.

Brian Peasey
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 05 2005 - 16:20:58 CDT