Re: Viewing Data in the Oracle8i Database

You shouldn't be using root to install Oracle. You should have a normal Unix/Linux account setup for that .

The system/manager should work, unless you changed the password which you should do anyway.

To change the password of SYSTEM, connect using SYS with command = sqlplus internal
Then enter at prompt SQL> alter user system identified by whateverpwyouwant ;

I see other posters don't think using system is a good idea. I know using SYS is definitely NOT something you should ever do unless absolutely necessary like upgrades - or a quick password change from sys :)

But, could someone tell me a good reason to not use the SYSTEM account for day to day DBA work.

For easier viewing of data by those not familiar with Oracle's catalog, using a tool like TOAD (free version at www.toadsoft.com) is useful. But, it only runs on Windozes. Another good one for Linux is TORA .

-- 
"Cliff J" <jonescj_at_optonline.net> wrote in message
news:df7ad293.0306241646.479f11d2_at_posting.google.com...


> Hi,

> I am new to Oracle. I am a network guy who is trying to get some

> knowledge using Oracle. I installed Oracle8i. All I want to do is log

> in as with the root account and look at the example database that

> comes with the install. I try to log in to SQL using the

> System/Manager account but I don't have sufficient privileges to look

> at data.

> My questions are, is there a built-in "admin" account that I should be

> using to administrate the database and is there a GUI that I can use

> to view data?

> Thanks. I appreciate it.