This topic is READ ONLY
import-bot (20211) [Avatar] Offline
#1
Re: Why I meet ORA-00942 ?
[Originally posted by johnlatham]

> Hi, Tom,
>
> I buy your book and finish installing the source code.
> When I try to use PB to see the 'Data Source' of 'Data Windows' in source
code,
> why I still met "ORA-00942, .... Do you want to continue in graphic mode? '
> information, and I can't see any content in that page?
>
> regards,
>
> Peter

ORA-00942 is the message number 'table or view does not exist'.
From the online Oracle documentation - "The table or view entered does not
exist, a synonym that is not allowed here was used, or a view was referenced
where a table is required. Existing user tables and views can be listed by
querying the data dictionary. Certain privileges may be required to access the
table. If an application returned this message, the table the application
tried to access does not exist in the database, or the application does not
have access to it."

Things to check -
1)the spelling of the table or view name.
2)that a view is not specified where a table is required.
3)that an existing table or view name exists. Contact the database
administrator if the table needs to be created or if user or application
privileges are required to access the table.
Also, if attempting to access a table or view in another schema, make certain
the correct schema is referenced and that access to the object is granted.

I hope this helps
import-bot (20211) [Avatar] Offline
#2
[Originally posted by mckan]

Hi, Tom,

I buy your book and finish installing the source code.
When I try to use PB to see the 'Data Source' of 'Data Windows' in source code,
why I still met "ORA-00942, .... Do you want to continue in graphic mode? '
information, and I can't see any content in that page?

regards,

Peter