Database Explorer does not show all objects, even if 'Show All Objects' option is enabled for the connection.
Hi Team!
I faced an issue with Database Explorer View when it does not show all objects, even if 'Show All Objects' option is enabled for the connection.
The problem seems relates to the fact that query:
- SELECT * FROM ALL_OBJECTS
- WHERE OWNER = 'MY_SCHEME'
does not return all objects I have.
However all of them are still accessible through DBA_* synonym:
- SELECT * FROM DBA_OBJECTS
- WHERE OWNER = 'MY_SCHEME'
My understanding is that Database Explorer UI uses first query to build the objects tree, instead of using the second one. So actually 'Show All Objects' checkbox does not do what it says it should do. Unfortunatly this is blocking issue for me. Other IDEs I've checked (Oracle SQL Developer, Toad, DataGrip) do not have this problem and list all objects correctly even if they are not visible through ALL_* synonym, but only appear in DBA_*.
Can you please confirm this is expected behaviour? Can it be fixed or if there some workaround for this?
App Version: dbForge Studio 2023, v4.5.21
Thanks!