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