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 -> Re: Ynt: Creation of Oracle databases

Re: Ynt: Creation of Oracle databases

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 26 Jun 2001 19:32:49 +1000
Message-ID: <3b3856fc@news.iprimus.com.au>

"TurkBear" <noone_at_nowhere.com> wrote in message news:6r9fjtgr7mkh377ckc2giem0tuj2rc3ro5_at_4ax.com...
> Thanks, Howard..I too hate sloppy language, and I had a 'supermodel
 moment' when
> replying..As you correctly gathered I was trying to show the analogy to
 the MS
> world...
> I might quibble however about Instances not having stuff..
> If I have 2 or 3 instances running on my server, each of them can access
 only
> those objects contained in that instance without involving database links
 ( a
> term that tends to continue the confusion of terms) , so , in that sense,
 the
> instance does 'have' schemas and the schema objects...
>

What objects are 'contained within an Instance'?? Sure, there is data and so on *cached* within the various bits of an Instance, but that's only a holding ground. Switch the power off, and away they go. Those objects really are contained, physically, within the database, and nowhere else... to say otherwise would be to suggest that when you look in a mirror, your face is 'contained within' the mirror (and I had rather hoped that my face was secured permanently to the top of my shoulders!).

At startup, there'd be barely a morsel of anything very much within the Instance. Everything only gets put there after being read up from the physical database.

I suppose this is probably just wordplay at the end of the day, and I know what you mean... I just deal with students every week who get confused between 'starting up' an Instance and 'opening' a Database, and think they can 'shutdown a Database'... so I get a bit pernickety about the distinction.

Regards
HJR Received on Tue Jun 26 2001 - 04:32:49 CDT

Original text of this message

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