Saturday, September 26, 2020
How to find dependencies of a package/table/view in Oracle (DBA_DEPENDENCIES and DBMS_UTILITY.GET_DEPENDENCY)
Before changing a package or procedure or view or table, we use check its dependencies using either of below options. It’s pretty much useful. Hence, shared the same. Hope it helps!!
Table: DBA_DEPENDENCIES
This table contains all basic information about the dependent object at first level. So, if I want to know the direct dependencies of PO_HEADERS_ALL, below query is useful.
Utility: DBMS_UTILITY.GET_DEPENDENCY
This utility is pretty much useful when we want to know the
dependencies in multiple level. Like we need data like below, while searching for dependencies of Y object.
- X object is dependent on Y object
- Z object is dependent on X
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “How to find dependencies of a package/table/view in Oracle (DBA_DEPENDENCIES and DBMS_UTILITY.GET_DEPENDENCY)”
Post a Comment