Re: table or view does not exist

Also:

If he's using o/s authentication, he could apparently be logging on as Scott/Tiger, but actually getting on as someone completely different (eg, SYS). A query on 'noschema.table' would therefore not default to 'scott.table'.

Hence the recommendation to select user from dual to *prove* he's actually on as Scott.

Regards
HJR <rspeaker_at_my-deja.com> wrote in message news:8cagi4$9ek$1_at_nnrp1.deja.com...
> 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