Cannot See Packages or Tables?

[SURFThru]

I have been using PL/SQL Developer for many years, love it.

Recently I installed in on another Windows 2008R2 server. On that server I connect to 4 developer regions (dev,tst,qa,prod).

I cannot see any tables or packages in qa or production. BUT on my other Windows 2008R2 machine I login to PL SQL with the same user id and password I can see all the objects with no problem.

So I know the issue is not with rights, I have been using the product for years. After the install on a new machine this starting happening.

Any help would be appreciated.

 

[Marco Kalter]

This can either be caused by:

• The "Use DBA views if available" preference (Tools > Preferences > Oracle / Options) is disabled. When enabled, PL/SQL Developer will use the dba_xxxx views instead of the all_xxxx views.
• The current Object Browser Filter above the Object Browser can filter out the objects you were expecting to see.
• The current Object Browser User above the Object Browser does not own the objects you were expecting to see.

 

[SURFThru]

Marco, I tried your suggestions and still have the same issue.

Just to clarify: On the two machines I have this installed they are both running on 10.2.0.4. One machine I can see packages, the other I cannot.

I compared all settings and filters that match on both machines.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem on both PC's and send me the debug.txt files that are generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).