Re: looking for opinion

Cameron Abbott wrote:
>
> I have to move two databases from two different servers to one server. The
> question here is do I create two different databases on the new server or
> one large database consisting of the two original databases, each having a
> diffect schema? Which would be more efficient?
>
> Thanks

Since every database/instance has some overheads (memory and disk), a single database (with different schema) will more *efficient*. You may however want to consider the usage types.

Are they both 24x7 etc?
Is there going to be hassles if you want to bounce the db just for the needs of one of the apps ?
Do you need to have a simple way of disabling access to just one app? Will any object names cause collisions ?

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."