Re: understanding oracle terminology - instance, database, sid, schema
From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Thu, 24 Jun 2010 09:51:01 -0700 (PDT)
Message-ID: <b62ad518-2bb8-48e7-b03b-587cad8368cb_at_k39g2000yqd.googlegroups.com>
On Jun 24, 5:24 pm, The Quiet Center <thequietcen..._at_gmail.com> wrote:
> hi, I'm an open source developer who has been cast into the wide wide
> world of Oracle. As a former MySQL user mainly (no boos please :),
> there is a lot of Oracle terminology that I dont understand.
>
> Specifically:
> - instance
> - database (it appears that a single host and port can have several
> databases)
> - sid
> - schema (it appears that a single database can have several schemas
> and that a schema is a collection of tables, views, triggers, etc)
> - user (it appears that a user can have access to various schemas and
> various permissions within schemas... contrast with MySQL where there
> are only databases)
>
> Beyond definitions for the above, my goal is to ask: how do you
> uniquely identify a schema? We are running both 10g and 11g here and
> so we cannot truly refer to a schema by the name alone without
> qualifying it with the database. But since the word "instance" is
> being thrown around here as well, I have to wonder what is meant by
> that also.
>
> Thanks,
> Terrence
Date: Thu, 24 Jun 2010 09:51:01 -0700 (PDT)
Message-ID: <b62ad518-2bb8-48e7-b03b-587cad8368cb_at_k39g2000yqd.googlegroups.com>
On Jun 24, 5:24 pm, The Quiet Center <thequietcen..._at_gmail.com> wrote:
> hi, I'm an open source developer who has been cast into the wide wide
> world of Oracle. As a former MySQL user mainly (no boos please :),
> there is a lot of Oracle terminology that I dont understand.
>
> Specifically:
> - instance
> - database (it appears that a single host and port can have several
> databases)
> - sid
> - schema (it appears that a single database can have several schemas
> and that a schema is a collection of tables, views, triggers, etc)
> - user (it appears that a user can have access to various schemas and
> various permissions within schemas... contrast with MySQL where there
> are only databases)
>
> Beyond definitions for the above, my goal is to ask: how do you
> uniquely identify a schema? We are running both 10g and 11g here and
> so we cannot truly refer to a schema by the name alone without
> qualifying it with the database. But since the word "instance" is
> being thrown around here as well, I have to wonder what is meant by
> that also.
>
> Thanks,
> Terrence
Not exactly an answer to your questions, but I guess following document might help you comparing Oracle vs. MySQL: http://download.oracle.com/docs/cd/E12151_01/doc.150/e12155/overview_mysql.htm
HTH
-- JeroenReceived on Thu Jun 24 2010 - 11:51:01 CDT