object dependency - cheeyoung/sqlplus-public GitHub Wiki

objects loaded in a cache

• v$object_dependency view

objects in a database

• dba_dependencies view
• deptree table in rdbms/admin/utldtree.sql script
• get_dependency procedure (in dbms_utility package) was deprecated in 12.2

References

9.95 V$OBJECT_DEPENDENCY 21c

3.117 ALL_DEPENDENCIES 21c
B.2 Creating Additional Data Dictionary Structures 21c
179.1 DBMS_UTILITY Deprecated Subprograms 12.2