Thursday, July 19, 2012

Find all dependent objects in oracle

Yesterday I had a scenario where I need to find the objects that are dependent on a particular table in Oracle 10g. My friend Peter happily offered me the following code.
select *
from dba_dependencies dep
where dep.referenced_owner = 'TABLE_OWNER_NAME'
and dep.referenced_name = 'TABLE_NAME'
order by owner, name;

No comments:

Post a Comment