Re: multiple databases

Yasaswi Pulavarti wrote:

> Hans:
> Howard Rogers in the earlier post clarified all my questions. However
> I did want to get back to you. What I mean by a database is a
> "collection of tables" that span over multiple tablespaces. You are
> right about different vendors treating databases differently. In DB2
> for example you can have one Instance and have many databases in that
> one instance.
> However I guess in Oracle, Instance and Database mean the same or in
> other words one instance can have only one database.
> Thanks,
> Yasaswi

No no no.

A database is a collection of related physical files ... datafiles, tempfiles, control files, log files. An instance is the related processes in memory. One database can support many instances ... which is what is called Real Application Clusters (RAC). So the 1:1 is not correct.

Database in DB2 = Schema in Oracle. One database in Oracle can contain many schemas.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)