Re: Accessing the Seed databse

Thanks guys for all your help. I was able to access the HR schema. What I did was unlock the HR account. Then I logged into the database with HR and hrpassword as password. Select * from jobs; command worked. Now I can follow the book step by step

Ken

"Ken Endeley" <kenendeley_at_lycos.com> wrote in message news:3e1ae54c$0$1398$8e9e3842_at_news.atx.net...
> 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
>
>
> "David Sharples" <david.sharples3_at_ntlworld.com> wrote in message
> news:T7mS9.1990$Gn6.24434_at_newsfep4-gui.server.ntli.net...
> > what have you tried to do and what errors are you getting. Need
> > infoformation to help you
> >
> > "Ken Endeley" <kenendeley_at_lycos.com> wrote in message
> > news:3e19e8d0$0$1407$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 jobs and employees table.
> > >
> > >
> > >
> > > Can anyone help please?
> > >
> > >
> > >
> > > Thanks
> > >
> > > Mfon
> > >
> > >
> >
> >
>
>
Received on Thu Jan 09 2003 - 08:55:05 CST