Re: Newbie Question: Adding A Database

Sadly (for you) it is an excellent hint.

By not getting aquainted with the basics, you are about to embark on a path of mistakes that will make your investment in Oracle (be it money or time) a total waste. Unless you are vastly different from 90%+ of the people who come to this forum asking the same question.

Now, do you want a new database, or a new schema? If the former, look at DBCA (database configuration assistant). If the latter, look at SQL Plus and use the CREATE USER command with the appropriate GRANT statements.

I suspect you want a new schema - but I don't know your requirements and until you read (or at least skim) the Database Administration Guide at http://docs.oracle.com or http://tahiti.oracle. com, I'd guess you probably will not be able to ask the question in a way I can understand.

You might also want to look at http://otn.oracle.com and look for 'Sample Code' and 'Oracle By Example'.

/Hans

the clansman wrote:

> Not very a good hint but it's your opinion. Thanks anyways.
>
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1065562022.870936_at_yasure...
> > the clansman wrote:
> >
> > >Hi,
> > >
> > >Using Oracle 8.1.6, how do I add a database? Using the DBA Studio, I
> > >selected "Add Database To Tree..." from the menu and I filled in the
> > >information
> > >
> > >Hostname: Localhost (it's on the same box)
> > >Port: 1525 (I already have another one on 1521)
> > >SID: VINTAGE
> > >NET Service Name: VINTAGE
> > >
> > >My problem is when I try to connect to it. What should I enter as the
> > >Username and Password since I never been asked for it? I tried the usual
> > >SYSTEM/MANAGER Stuff (which works for my other database) but no success.
> Is
> > >there's another step to perform prior creating a database?
> > >
> > >Thanks.
> > >
> > >
> > The first thing you should do is recognize that Oracle is not SQL Server
> > (or Sybase or Informix) and that
> > you are misusing terminology.
> >
> > What you think of as a database is a user/schema in Oracle. Go to
> > http://tahiti.oracle.com and learn the Oracle
> > definitions of the words you are using. Star with these:
> >
> > database
> > instance
> > schema
> >
> > Also recognize that Oracle's architecture is completely different from
> > that of all other major commercial RDBMS
> > products and you should not be doing anything until you can competently
> > explain the concepts behind multiversioning,
> > locking, and transaction processing.
> >
> > --
> > Daniel Morgan
> > http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> > http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> > damorgan_at_x.washington.edu
> > (replace 'x' with a 'u' to reply)
> >

--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]