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.
| 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 |
| DEPENDENCY_LEVEL | Hierarchy level in the dependency graph |