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