Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Instances
Just a suspicion but ... The first thing, and most important thing, is
that Oracle is NOT SQL Server. Your use of the word databases is not
in-line with Oracle terminology ... and what you mean is schemas.
There are no drawbacks to multiple schemas in an instance. The benefit is ease of management.
Daniel Morgan
Eric Bonnet wrote:
> Hi there,
>
> I'd like to know if it is better to have one instance holding several
> databases or several instances and several databses as well ? What are
> the benefits / drawbacks of each solution ?
>
> Thanks,
>
> Eric
Received on Mon Mar 11 2002 - 11:35:41 CST