Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing the Seed databse
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.deReceived on Tue Jan 07 2003 - 11:09:08 CST