PL/SQL Developer now showing certain objects in schema

[alkooyer]

Hello all,

This is my first post, so feel free to direct me to other posts/links if they exist and are related to this topic.

When browsing certain schemas in PL/SQL Developer, the objects do not appear in the Object Browser. They do exist per our Oracle DBA, and do appear in Oracle's SQL Developer tool, but they do not show in PL/SQL Developer. We have had multiple users with different OSs (Windows XP and 7) try to view the objects and no one can view them. Any ideas? I have screenshots and will attempt to attach them.

Thank you!

PL/SQL Version: 9.0.6.1665
Oracle SQL Developer Version: 3.2.20.09

 

[IvanZ]

Hello.

Make sure your user have privilege to view the objects you cant see in the Object Browser.

Try option 'Use dba views if available"

 

[alkooyer]

Thank you for responding! I enabled the option, restarted PL/SQL Developer, and now the objects are appearing.

Just an FYI. Before trying the option you mentioned, another developer here noticed that PL/SQL Developer is using a list from ALL_OBJECTS, where Oracle SQL Developer is using a list from the DBA_OBJECTS view.