SQL DEVELOPER does not list all the views I can see thru select * from all_views
Why I can see the view using the query builder and the Sql Developer do not show the views on the left pane?
I already checked the option 'include synonyms' from the filter.
I am not the owner of the view.
EDITED:
I found the answer with the help of Glenn and Sean
The answer is:
1 - you have to go to your oracle conection
2 - right click and select 'Schema Browser'
3- Now you can select the schema and see the views it have.
Regards
all_views (as well as the other "all_*" tables) only show entries in your schema or that you have access to. dba_views will show all views in the database. Your user probably does not have read access to the view via direct grants to your user or granted through a role.
all_views - all views you have access to + views in your user's schema user_views - all views in your user's schema dba_views - all views in the database
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With