Re: Accessing the seed database

From: Alison Holloway <Xalison.holloway_at_oracle.comX>
Date: Wed, 08 Jan 2003 11:07:40 +1100
Message-ID: <3E1B6BCC.6030703@oracle.comX>

Ken,

I think you might be trying to get to the new HR schema, and not the SCOTT schema. The HR schema has the following tables:

BONUS
COUNTRIES
DEPARTMENTS
DEPT
DUMMY
EMP
EMPLOYEES
JOBS
JOB_HISTORY
LOCATIONS
REGIONS
SALGRADE Log in as user HR and you should be able to access the tables. There isn't a default password for this user; you would have had to create your own password for HR. If it isn't installed, read the Sample Schemas Guide at:

   http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96539/toc.htm

Hint: Run $ORACLE_HOME/demo/schema/human_resources/hr_main.sql

Alison

Ken Endeley wrote:
> Oracle 9.i Release 2(9.2.0.1.0)
> Win2k Professional
>
> I login to SQL*plus with username:scott Password:tiger
>
> then at the prompt I type
>
> select * from jobs;
>
> I get an error message saying :
>
> Error at line 1:
> ORA-00942: table or view does not exist.
>
> I am not sure if the table is availabe or if I'm logged in with the correct
> password
>
>
> Thanks
> Ken
> kenendeley_at_lycos.com
>
> Oracle Newbie
>
>
>
> "Ken Endeley" <kenendeley_at_lycos.com> wrote in message
> news:3e19e8b6$0$1396$8e9e3842_at_news.atx.net...
>

>>I have just finished installing Oracle 9i personal edition and I am trying
>>to access the seed database but I can't. Specifically, I am trying to

>
> access
>

>>the job and employees table.
>>
>>
>>
>>Can anyone help please?
>>
>>
>>
>>Thanks
>>
>>Mfon
>>
>>

>
>
>
Received on Tue Jan 07 2003 - 18:07:40 CST