ORA-00904 when trying to access object details

[Robert_L]

Hi

Since a couple of days I'm receiving an ORA-00904 when trying to access any details of e.g. tables or functions etc.
I'm on XP with having a 9.2.0.1 Oracle client installed.
SQL+ works fine and PL/SQL Dev (5.1.4) also worked fine before.
Still I can access session details with PL/SQL Dev on the server. Account has all necessary access rights.
Has anybody any ideas?

Thanks
Robert

 

[Marco Kalter]

I'm not sure what could cause this. Can you verify if it helps if you change the "Use DBA views if available" preference?

If the problem is caused by a specific preference setting (which could explain why it still works on the server), then you can temporarily clear these preferences by renaming the following registry section:

hkey_current_user\software\allround automations\pl/sql developer

You can rename it back after testing this.

 

[Robert_L]

Hello,

I fixed on late Friday via having it reinstalled with my normal XP-user and temporary admin rights after having it completely unstalled before.
At another desk it seem to be sufficient that he reinstalled it with XP standard user without any additional admin rights as files and folders already existed. So it looks like the issue is solved.
Thanks
Robert Lohmann