Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle "Instance" same as SQL Server "Database"?

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

From: Eric Yu <ericyu_at_NOSPAM.centerprise.com>
Date: Mon, 13 Sep 1999 17:51:47 -0400
Message-ID: <hneD3.291$H26.6727@client> 





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)?



Thanks in advance for any education here.



/EY



Received on Mon Sep 13 1999 - 16:51:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US