Re: table or view does not exist

From: <rspeaker_at_my-deja.com>
Date: 2000/04/03
Message-ID: <8cagi4$9ek$1@nnrp1.deja.com>#1/1

try connecting as scott/tiger and running

select table_name from user_tables; to see if perhaps the create table statement failed or perhaps the name got misspelled.

In article <8c2n7r$490$1_at_nnrp1.deja.com>, matt_at_bomb.co.uk wrote:
> Hi All,
> I'm a newbie to Oracle8 and so hopefully this can be answered easily
> enough.
> I'm having problems simply viewing table contents of table that I
> created.
> Can only connect to using scott/tiger and when I create a table 'test'
> it cannot viewed.
> Using - 'jdbc:oracle:thin:scott/tiger_at_leeds:1521:orc1'
> SQL - 'SELECT * FROM test'
> But the other tables can be viewed ... eg scott.emp
> error message - 'ORA-00942: table or view does not exist '
> Can anyone help me with this... please
> bye
> Matt.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 03 2000 - 00:00:00 CDT