Re: Database vs. Instance ?

On Wed, 25 Feb 1998 13:21:32 +0200, Leo Salminen <leo.salminen_at_ntc.nokia.com> wrote:

>If we follow that Oracle concept, there is two SCOTT users in one
>database or have I misunderstood some very basic idea ?

I think you misunderstand the concept a little. An "instance" is a database that is "loaded" into memory and "running." An instance is accessible to the users/clients.

A "database" is the physical set of files and their contents (tables, user definitions, etc...).

A database can have an instance, that's when you load Oracle on the server and tell it to "start up" a database. Then you have an instance of the database.

I do not think you can have two instances of the same database running at the same time on the same server.

>Does anyone know, why do Oracle define users and schema objects as parts
>of database, not as parts of an instance ?

Because the instance is gone as soon as you shut it down.

gg Received on Wed Feb 25 1998 - 00:00:00 CST