How to find the Dependent objects of particular object in oracle
select t.name,t.type,s.status from dba_dependencies t ,dba_objects s where t.referenced_name='<object name >' and t.name=s.object_name;
NAME TYPE STATUS
------------------------------ ------------------ -------
JJ VIEW VALID
DD VIEW INVALID
No comments:
Post a Comment