View Dependencies

This post will help to get the underlying tables of the views . 

create view sample_V as select a.* from user_rep.opb_subject a inner join user_rep.opb_mapping b 

on a.subj_id=b.subject_id ;

select Name , type , referenced_name , referenced_type

from USER_dependencies where   type = 'VIEW' and

referenced_type = 'TABLE'    

 

Note : SysAdmin Login see the all the base tables of the view by referring  

dba_dependencies   (By using the filter on the column named owner )

The view 'USER_DEPENDENCIES' will give the dependencies of logged in user.

The view 'DBA_DEPENDENCIES' will give the dependencies of all the users.

 

--