Re: Multiple database in one instance

From: Yong <yhuang_at_indigopool.com>
Date: Tue, 22 Aug 2000 09:47:58 -0500
Message-ID: <8nu410$r8m$1@news.sinet.slb.com>

David Grzebien <dgrzebie_at_columbus.rr.com> wrote in message news:39A1E049.F7FFBA0E_at_columbus.rr.com...
> Let's define what a database is and an instance.
>
> A database is a collection of related data.
> An instance (in Oracle) are the background process that run Oracle (ie.
> SMON, PMON, etc).
>
> With this in mind, it is possible to create many databases in one
instance.
> I would probably create them in separate schemas as well.

You probably meant "it is possible to create many instances for one database". Not sure what you mean by "create them in separate schemas".

Yong Huang
yhuang_at_indigopool.com Received on Tue Aug 22 2000 - 09:47:58 CDT