Re: Many Small Oracle Databases

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 22 Jan 2004 16:40:44 +0100
Message-ID: <buoqtt$bto$1@news.fujitsu-siemens.com>

"Hans Forbrich" <hforbric_at_yahoo.net> schrieb im Newsbeitrag news:400FE842.B0FC2F5C_at_yahoo.net...

> Charles wrote:

> > Are you creating individuals Oracle SIDs for all kinds of small
> > databases for deparmental apps?

I don't.

> > Do you have one large-ish Oracle SID that you create multiple schemas
> > in for each "separate" database request that you get?
Yes.

> > I'd sure appreciate hearing how DBAs working in a large enterprise
> > handle this.

We are not a large enterprise but my suggestion would be to assign schemata and only if there are wildly incompatible requirements (for instance different versions) to maybe maintain two or three databases and put the schemata in the db that best matches their requirements.

Lots of Greeetings!
Volker Received on Thu Jan 22 2004 - 09:40:44 CST