LLI Wiki — My Digital Knowledge Base

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

Mastodon LLIMastodon SocialFosstodon