Lists all the direct dependencies between schema objects. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Dependencies between scripts cannot be determined. In case of a view, entries with REFERENCE_TYPE=NULL values can be shown if underlying objects have been changed, and the view has not been accessed yet.

Column Name Description
OBJECT_SCHEMA Schema of object
OBJECT_NAME Name of object
OBJECT_TYPE Type of object
OBJECT_OWNER Owner of the object
OBJECT_ID ID of the object
REFERENCED_OBJECT_SCHEMA Schema of the referenced object
REFERENCED_OBJECT_NAME Name of the referenced object
REFERENCED_OBJECT_TYPE Type of the referenced object
REFERENCED_OBJECT_OWNER Owner of the referenced object
REFERENCED_OBJECT_ID ID of the referenced object