Re: Graphical Oracle administration

From: <>
Date: Thu, 22 May 2008 10:26:49 -0700 (PDT)
Message-ID: <>

Comments embedded.
On May 22, 10:24 am, Luigi <> wrote:
> I've searched the internet and as far as I can understand in SQL
> Server 2005 and Oracle we have:
> An instance (server) can have many databases.

Not with Oracle. You have basically two possibilities with Oracle:

  1. 1 instance, 1 database.
  2. 2 or more instances, 1 database (RAC)

Your reference would be the first in this list, a 1 instance:1 database configuration for Oracle. 1 database: many schemas with Oracle.

> A database can have many schemas, schema simply being a grouping for
> objects in a database:

Correct for Oracle.

> there can be two tables named "Product" one in
> the schema Sales and the other in the schema Manufacture
> (Sales.Product and Manufacture.Product)


> Hence a fully qualified object name is server.database.schema.object.

For SQL Server you're correct. For Oracle, no, as a 'fully qualified' object name would be SCHEMA.OBJECT_NAME. Accessing an object in a different Oracle database would require a database link, and would then make the 'fully qualified' name SCHEMA.OBJECT_NAME_at_REMOTE_DB.

> Am I right?
> Thanks,
> Luigi.

David Fitzjarrell Received on Thu May 22 2008 - 12:26:49 CDT

Original text of this message