Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Rule of thumb for new schema vs. new database?

Rule of thumb for new schema vs. new database?

From: BP <brian.peasey_at_gmail.com>
Date: Wed, 5 Oct 2005 16:08:32 -0500
Message-ID: <ff2080f40510051408r487aa8ddpd371315d8edfb6eb@mail.gmail.com>


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
Received on Wed Oct 05 2005 - 16:11:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US