This table lists all the direct and indirect dependencies between schema objects (thus recursive). Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
- Dependencies between scripts cannot be determined. Views are not shown if underlying objects have been changed, and the view has not been accessed yet.
- All database objects are read when accessing this system table.
|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|
|DEPENDENCY_LEVEL||Hierarchy level in the dependency graph|