select * from dba_dependencies dep where dep.referenced_owner = 'TABLE_OWNER_NAME' and dep.referenced_name = 'TABLE_NAME' order by owner, name;
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.