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.

  1.  X object is dependent on Y object
  2.  Z object is dependent on X




 

0 Responses to “How to find dependencies of a package/table/view in Oracle (DBA_DEPENDENCIES and DBMS_UTILITY.GET_DEPENDENCY)”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.