Oracle: list an object's dependencies with DBA_DEPENDENCIES
Query DBA_DEPENDENCIES to find the objects a view or PL/SQL program depends on.
To find which objects an Oracle view, procedure or package depends on (tables, views, functions...), query the DBA_DEPENDENCIES dictionary view.
SELECT *
FROM dba_dependencies
WHERE name = 'MY_VIEW';
The query returns one row per object referenced by MY_VIEW: the REFERENCED_OWNER, REFERENCED_NAME and REFERENCED_TYPE columns identify the object it depends on. For the reverse analysis (what depends on an object), filter on referenced_name instead of name.
Notes
DBA_DEPENDENCIESrequires DBA privileges;ALL_DEPENDENCIESandUSER_DEPENDENCIESexist for the objects accessible to the current user.- Add
AND owner = 'APP_SCHEMA'if the same name exists in several schemas.