Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing the Seed databse

Re: Accessing the Seed databse

From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Date: Tue, 7 Jan 2003 18:09:08 +0100
Message-ID: <PM0003B3A810D57419@hades.none.local>


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

[...]

Hello Ken,
try this:

select table_name from user_tables;

Then you will see what tables are there.

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de
Received on Tue Jan 07 2003 - 11:09:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US