EXA_DBA_DEPENDENCIES​_RECURSIVE

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