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 |
REFERENCE_TYPE | Reference type (VIEW, CONSTRAINT) |
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 |