Re: oracle newbie

Cesar,

IF you have a starter database installed, then it should be possible to connect

with SYSTEM/MANAGER. This is the internal DBA account. Use it to create other users, like

create user cesar identified by loi
default tablespace users
temporary tablespace temp
quota unlimted on users
;

You may leave out the middle three lines.

After that, issue:

grant connect, resource to cesar
;

You're in business now!

If there's no database yet, you'll need to create one. This is possible with the
Database Assistant.
One piece of advise upfront: do use the SYSTEM account sparingly; together with SYS, these are the oracle internal superusers.

Good luck! Frank
cesar wrote:

> i need help.
>
> i installed oracle 8 in my computer. there are many programs created under
> its heading after its the installation. And as a beginner, I don't know
> where to start. I tried some of the programs, e.g. SQL+, but like other
> programs under oracle 95, it looks for username and password. there is
> though an oracle net assistant but have not explored.
>
> Can you help and guide on how to use this oracle software 8? Please advise
> me.
>
> thank you very much for your help.
Received on Tue Dec 29 1998 - 11:37:05 CET