Toad World® Forums

ORA-00942 problem and sugestion


#1

When SQLNav gets an
“Error when opening a DB object: ORA-00942: table or view does not exist”
it should refresh the DB Navigator (or ask "do you want to refresh DB Nav?)

I also got a situation where a package body was invalid and it gave me always: ORA-00942: table or view does not exist …and would open a empty panel. In the bottom of the panel the creation date and modified were correct (with INVALID in the next cell)

The only way to solve that was to restart the SQLnav…maybe it was an memory problem like the ones in sql nav 5.5, but without showing that error that in the console?


#2

Hi!
Try with “using dba views” option unchecked, then Sqlnav uses all_% views against dba_% views…


#3

That error only occurs sometimes.

where can I find that option in Preferences…I know I saw it somewhere but I was not able to find it now.


#4

Hi Filipe,

it can be found under General->Session. I have attached the screen capture for your reference.

Regards,
Bruce
pref.jpeg