Re: What is a Catalog and Database according to Oracle?

Joseph Weinstein <joe_at_weblogic.com> wrote in message news:37E7C6AF.95F161DA_at_weblogic.com...
> At 08:49 PM 9/20/99 -0400, you wrote:
> >If a 'user' corresponds to the term 'schema' then what do you call the
collection of
> >schemas that a user has access to?
>
> These are just the collection of schemas that a user has access to.
> If the permissions in the database are such that one user can refer
> to another user's tables, then so be it. The SQL will have to
> explicitly qualify the schema for any object not in the current (users)
> schema. In MS SQLServer, a fully qualified name is:
>
> select * from <catalog>.<schema>.<tablename>
>
> If catalog is left out, it is assumed to be the current catalog/database.
> if schema is left out, it is assumed to be the current users, but if no
> such table belongs to the user, then the system schema is checked.
>
> >Are you saying that the terms "catalog" and "database" can be used
interchangeably?
>
> Yes. In the case of Oracle, it is also synonymous with the Oracle
instance. An
> Oracle instance contains only one set of system tables (a catalog). A
single
> MS SQLServer instance can be subdivided into numerous autonomous
databases,
> each with it's own set of system tables and memory space. Each of these is
called
> a database. An MS SQLServer user can select from tables in any or all
databases
> to which he has permission, by fully qualifying the query.

No.
Oracle doesn't use the term "catalog" as a database. For example, you have a family name, you have a nose, can your name and your nose can be used interchangeably?

[snip] Received on Sat Sep 25 1999 - 11:54:20 CDT