Re: still cannot see data in tables - plz help

Thanks .... for the hint with the 'manual' .... trying to type HELP in sql plus ...I get the message 'no acces to help'

by the way .... I have granted access to PUBLIC ... therefore I shouldn't have to type in the schema as well ...or should I ??!!

as it works fine now with just tablename.colname - and I am glad about!!

I have got the table cols mixed in a connecting table so the second table never showed up as the query wasn't correct anymore..

thought I could save some time in using my old scripts ...... rather than creating new ones with the data and colnames exported from access

yeap ... I have to admit ... that was rather silly!!

how can I get the 'HELP' working when typed in SQL PLUS ??? or am I wrong here again??

Louise

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:998197891.12434.0.pluto.d4ee154e_at_news.demon.nl...
>
> "Louise" <louise_mc_dowell_at_hotmail.com> wrote in message
> news:3b7eb379_3_at_mk-nntp-1.news.uk.worldonline.com...
> > Hi all.
> >
> [snip]
>
> > When starting up that application I get a message:
> >
> > java.sql.SQL.Exception: ORA-00942: Table or View not available
> >
> >
> > When using SQL Plus I can see all the data in all tables!!
> >
> > the strange thing is that it must be somehow accessible as the boxes get
> > filled ..... what have I done wrong .. or what have I missed???
> >
> You didn't create any private or public synonyms so now your selects need
to
> read select * from tutor.foo, note the tutor. part.
>
>
> > I am struggeling along all day now .... and do not get anywhere... your
> help
> > would be most appreciated !!!
>
>
> If you would only stop to refuse reading manuals, you wouldn't have to
> struggle that hard.
> >
> >
> >
> > Louise
> >
> >
> >
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Sun Aug 19 2001 - 04:38:00 CDT