Re: Graphical Oracle administration
From: Luigi <newsgroupusr_at_gmail.com>
Date: Thu, 22 May 2008 08:24:48 -0700 (PDT)
Message-ID: <a668e46b-e505-452e-b69e-ee9adde600b1@x35g2000hsb.googlegroups.com>
Date: Thu, 22 May 2008 08:24:48 -0700 (PDT)
Message-ID: <a668e46b-e505-452e-b69e-ee9adde600b1@x35g2000hsb.googlegroups.com>
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.
A database can have many schemas, schema simply being a grouping for
objects in a database: 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.
Am I right?
Thanks,
Luigi.
Received on Thu May 22 2008 - 10:24:48 CDT