Re: Accessing the seed database

Oracle 9.i Release 2(9.2.0.1.0)
[Quoted] Win2k Professional

[Quoted] 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 [Quoted] password. I understand what you mean by schema. I am a complete newbie

Thanks
Ken
kenendeley_at_lycos.com

Oracle Newbie
"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E1A2519.854C896E_at_exesolutions.com...
> Ken Endeley wrote:
>
> > 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 jobs and employees table.
> >
> > Can anyone help please?
> >
> > Thanks
> >
> > Mfon
>
> If you provided some information no doubt someone could help you.
>
> I'll list what is missing from your post.
>
> 1. Can you log on in SQL*Plus?
> 2. If you can what user are loggin on as?
> 3. What schema do you think owns the jobs and employees tables?
> 4. What happens when you try to access the tables? You get a blue screen
of
> death? The machine freezes? You get an Oracle error message and didn't
think it
> important to post the five digit number and message text?
>
> If you can provide some useful information as to what is actually going on
...
> perhaps you can get something more useful back in return.
>
> Daniel Morgan
>
Received on Tue Jan 07 2003 - 15:29:59 CET