ORA-00942

[thaker]

Hi all,

When I open SQL window and type simple sql :
select * from tab (or any existing table)

gives error :
ORA-00942 table or view does not exist

This is happen in one database only, other two are working fine.

pls tell me whats wrong?
- thaker

 

[Marco Kalter]

Can you let me know your exact PL/SQL Developer version?

 

[thaker]

PL/SQL Developer version is : 5.1.3.704

SQL statement is workin in Report Window,
Command Window but not in SQL Window.

-thaker

 

[Marco Kalter]

Okay. My guess is that you have select privileges on some (but not all) of the following views:

• v$session
• v$sesstat
• v$statname

To fix the problem, obtain grants on all views. You can also disable the "Automatic Statistics" preference.