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 ) |