Re: Multiple database in one instance

From: David Grzebien <dgrzebie_at_columbus.rr.com>
Date: Tue, 22 Aug 2000 02:05:53 GMT
Message-ID: <39A1E049.F7FFBA0E@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.

Dave
dave_at_etci.net

woods_john_at_crane.navy.mil wrote:

> Is it possible to have more than one database per instance. If so, how?
>
> Thanks,
>
> John Woods
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Aug 21 2000 - 21:05:53 CDT