Thanks Howard. You clarified all my questions.
Yasaswi
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4199f8a7$0$27451$afc38c87_at_news.optusnet.com.au>...
> Yasaswi Pulavarti wrote:
> > In one SID or instance can I create three different databases?
>
> No, because in Oracle you don't create databases "in" anything... and
> certainly not in an instance. An instance is just the set of memory and
> processes which access and manage a database. And an instance can only
> ever open and manage ONE database.
>
> > Or does
> > the term "Single Instance Database" (SID)
>
> Don't invent acronyms, especially when they conflict with ones already
> in use. The term SID has a well-established meaning (as in "ORACLE_SID",
> the environment variable, where the SID bit means 'system identifier').
>
> > 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?
>
> Now I'm lost. You don't want to use DBCA and you don't want to run a
> script... how do you want to create a database then? Telepathy?
>
> All databases are created by the 'create database...' SQL command. You
> either construct that command using a nice GUI front end (i.e., DBCA),
> or you sit there typing it in the hard way, at the command line, in
> SQL*Plus. There are no other choices, really.
>
> What is it you don't like about either of them that sees you seeking an
> alternative mechanism?
>
> > Is there a text based interactive utility
> > to create databases in Oracle?
>
> No.
>
> I suspect you might find the Oracle Concepts Guide of use. You can find
> it at http://tahiti.oracle.com.
>
>
> HJR
>
> > Thanks,
> > Yasaswi
Received on Tue Nov 16 2004 - 16:38:14 CST
