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

  • From: "Hollis, Les" <Les.Hollis@xxxxxx>
  • To: <brian.peasey@xxxxxxxxx>, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 Oct 2005 16:17:35 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l

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

Other related posts: