Re: multiple databases

Yasaswi Pulavarti wrote:

> In one SID or instance can I create three different databases? Or does
> the term "Single Instance Database" (SID) mean only one database per
> instance? Also other than using the dbca (Database Congifuration
> Assistant) GUI utility, and other than just running a script, is there
> a way to create databases? Is there a text based interactive utility
> to create databases in Oracle?
> Thanks,
> Yasaswi

A database in Oracle is a set of physical files and bears no relationship to the use of the same word in other RDBMS products.

In Oracle one creates multiple users/schemas ... but not databases in the sense in which you are asking the question.

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