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

Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote in message news:7saqn1$cfj$1_at_soap.pipex.net...
>
> Joseph Weinstein <joe_at_weblogic.com> wrote in message
> news:37E7C6AF.95F161DA_at_weblogic.com...
>
> > >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.
>
> I know I am both new to all this (18m experience) and somewhat loose in my
> use of the word database, but I think I disagree.
>
> For me a database is the set of datafiles logfiles, control files etc that
> store data for access by an app. This is loaded into one or more instances
> which is the actual memory structure used to run the database. I guess I'm
> mainly thinking parallel server here. Damn that hasn't come out right at
> all, but does it make sense or do I need to a) write more clearly and b)
> repost
>

Sounds Ok to me parallel server or no

Alex Received on Wed Sep 22 1999 - 10:13:52 CDT