Re: difference between instance and database name?

From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: Mon, 21 Dec 1998 14:48:08 +0100
Message-ID: <367E5198.9105F0D5@fs-edv.de>

steve_young_at_my-dejanews.com wrote:
>
> What is the difference between instance and database name? I know this is a
> stupid question. But I always got confused.
>
> Thanks.
>
> Steve
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

The instance is a group of programs (to be more precise: tasks or threads) reading and writing from the database files server-side; the database is (as i know it) the database files itself (and the data contained).

Up to here, i hope the answer helps you.

But now the confusing part:
It is possible to have more than one instance running on one database (at the same time - don't ask me how this works); and on the other hand, one database may be spread over several computers.

Greetings

Arnold Schommer Received on Mon Dec 21 1998 - 07:48:08 CST