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
HansF <news.hans_at_telus.net> wrote in message news:<sgnmd.178895$9b.74522_at_edtnps84>...
> 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
>
> Please explain what you mean by database.
>
> Oracle has a specific definition. Other RDBMS vendors also have definitions
> but they are different from Oracle's (and each other's). The difference in
> definitions leads to a lot of confusion.
>
> No matter what definition you use, Oracle does not have an interactive
> command line utility to prompt you through database creation. Ultimately
> all you have is a script, and DBCA simply creates and runs the 'script'.
>
> Please exlpain what you are trying to accomplish (the business reason) so we
> can think of alternates that might help.
>
> /Hans
Received on Tue Nov 16 2004 - 16:43:36 CST
