Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ORACLE SQL DEVELOPER can't see all View

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

like image 661
ricardo Avatar asked Jul 13 '26 14:07

ricardo


1 Answers

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

like image 149
Sean Dulin Avatar answered Jul 16 '26 07:07

Sean Dulin