Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: What is a Catalog and Database according to Oracle?

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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 22 Sep 1999 15:57:08 +0100
Message-ID: <7saqn1$cfj$1@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

Niall Received on Wed Sep 22 1999 - 09:57:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US