Re: Accessing the seed database

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. 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
> >

By definition, then, the tables you are trying to access do not exist. Or at least not owned by SCOTT.

Before trying to query tables I would start by getting familiar with the Oracle Data Dictionary. Try the following queries and learn something about Oracle and the available objects.

SQL> desc user_tables

SQL> SELECT table_name FROM user_tables; -- all of the tables owned by the schema you logged in to

SQL> SELECT table_name, owner FROM all_tables; -- all of the tables accessible to the schema you logged in to

SQL> SELECT object_name, object_type FROM user_objects;

SQL> SELECT object_name, object_type, owner FROM all_objects;

SQL> SELECT object_name FROM all_objects WHERE object_name LIKE 'USER%';

And familiarize yourself with http://tahiti.oracle.com

Daniel Morgan Received on Tue Jan 07 2003 - 17:16:20 CET