ALL_DEPENDENCIES describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user, including dependencies on views created without any database links. This view does not display the SCHEMAID column.
DBA_DEPENDENCIES describes all dependencies between objects in the database. This view does not display the SCHEMAID column.
USER_DEPENDENCIES describes dependencies between objects in the current user's schema. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
TYPE |
VARCHAR2(17) |
Type of object | |
REFERENCED_OWNER |
VARCHAR2(30) |
Owner of the parent object | |
REFERENCED_NAME |
VARCHAR2(64) |
Type of parent object | |
REFERENCED_TYPE |
VARCHAR2(17) |
Type of referenced object | |
REFERENCED_LINK_NAME |
VARCHAR2(128) |
Name of the link to the parent object (if remote) | |
SCHEMAID |
NUMBER |
ID of the current schema | |
DEPENDENCY_TYPE |
VARCHAR2(4) |
Whether the dependency is a REF dependency (REF) or not (HARD) |