Re: Oracle "Instance" same as SQL Server "Database"?

On Mon, 13 Sep 1999 17:51:47 -0400, "Eric Yu" <ericyu_at_NOSPAM.centerprise.com> wrote:

>As a newby to Oracle coming from an MS/Sybase SQL Server background, am I
>correct in interpreting that an Oracle Instance is equivalent to a separate
>Database in SQLServer? Thus, to create a new logical database requires
>creating a new Instance with separate associated processes for each
>instance? Or may it also be appropriate to define & treat a Schema within
>an Instance as (semantically) equivalent to a separate Database (without the
>associated additional processes)?

As near as I can figure it, there is also a database (similiar to the idea with MS SQLServer) in Oracle that consists of physical files (datafiles, log files and control files). Where Parallel Server is not running, there can be one instance (would it be fair to compare it to a service in the NT world) per database. The differentiation comes when Parallel Server is running and then there are multiple instances with multiple instance names and one database name.

PS. There can also be multiple databases on one server. Is that the case with SQLServer?
--
Barth Siemens
Change the email address from nospam to bsiemens. Received on Mon Sep 13 1999 - 23:40:14 CDT