I'm trying to reconcile some Oracle terms with some ANSI SQL & JDBC
terminology and I'd like to know if I've made any mistakes. In other
word, which of the following statements are false and why?
- An "Oracle database" is an instance of an Oracle DBMS, thus if there
is more than one instance running on a computer then the computer has
more than one database running?
- Do Oracle DBAs use the terms "Oracle database" and "Oracle server"
interchangably? Or does "server" mean one computer with possibly
multiple databases running on it.
- Is an "Oracle user" the same as the ANSI SQL term "catalog"? If so,
then a Oracle user can have only one catalog? Do Oracle DBA's call a
catalog the "user's database"?
- The Oracle docs say that a user account can only own a single schema
which has the same name as the user name.
Therefore, a user's catalog or user's database (identified by the user's
name) contains one schema owned by the user (also identified by the
user's name) and portions of other users' catalogs/schemas which the
user has access to?
- An Oracle DBA can setup up additional user accounts, say 5, for the
same user ie, JSmith1, JSmith2... JSmith5. with different schema access
privileges; thus, simulating one ANSI SQL "cluster", defined as a
"group of catalogs" and not to be confused with Oracle cluster meaning?
- The scope of an "Oracle user" OWNERSHIP is limited to one database
-- the one it is defined on?
- The scope of an "Oracle user" ACCESS can span multiple databases
using dblinks? Therefore, a user's catalog can span multiple databases?
- "Oracle dblinks" allow remote objects in a different "Oracle
database" to be seemlessly included in a user's catalog? So, for
example, issuing one Oracle request for a list of all tables that a user
has access to will include any remote tables distinguished by datalink @
tablename syntax. ?
- Or is the same request also needed on remote database inorder to
discover the remote tables? If this true, how does the client app know
what datalink to use if it is not hard-coded in the app?
TIA,
--
Steven Hill
Received on Mon Sep 20 1999 - 14:42:54 CDT