Thursday, 28 January 2016

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.


No comments:

Post a Comment