Re: Where do I start?

Though I am not a great fan of GUI application ;-) I think i can help you with you problem:

The SYSDBA is a kind of role, though not a oracle DB role. The user "sys" can connect as sysdba. The change_on_install is the password for sys and manager is the password for system which is a sysoper

Remember to create a user for your tables and stuff - don't use sys or system.

But I agree with Mr. Bakker: Read the manuals - they are pretty good compared to other RDBMS' out there. @ work I am "forced" to learn sybase (which M$ SQL server originates from) and the documentation doesn't come close to oracle documentation i quality.

/Lehmann

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> skrev i en meddelelse news:tfkamb2irp2jb0_at_beta-news.demon.nl...
>
> "Brian" <brian_at_innovtech.com> wrote in message
> news:6wpK6.58579$qv3.23872847_at_nnrp5-w.sbc.net...
> > I admit I am brand new to Oracle. I have downloaded and successfully
> > installed 8i. I don't even know what the username and password is to get
> > into DBA studio? I think the username is SYSDBA and I though the
 password
> > was manager. During installation, it said something like
 change_on_startup
> > and manager.
> >
> > Also, where is a good place to get my feet wet? My primary interest is
 to
> > connect through servlets and jdbc. I have successfully done some of that
> > already with SQL7.
> >
> > Thanks for the help!
> >
> > -Brian
> >
> >
>
> There is only one sensible advice:
> Read those manuals!
> Start with the Oracle Getting Started Manual (sounds rather obvious
 doesn't
> it?)
> Read the Oracle Concepts Manual
> Forget everything you learned about Sqlserver.
> *Don't* try to *port* your sqlserver habits to Oracle,
> *learn* Oracle
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Thu May 10 2001 - 02:09:24 CDT