ALL_ASSERTION_DEPENDENCIES
ALL_ASSERTION_DEPENDENCIES displays the dependencies between assertions accessible to the current user and the objects they reference.
This view displays assertions owned by the current user, as well as assertions owned by other users that involve at least one table on which the current user has at least one of the following object privileges: SELECT, INSERT, UPDATE, or DELETE.
Related Views
-
DBA_ASSERTION_DEPENDENCIESdisplays the dependencies between all assertions in the database and the objects they reference. -
USER_ASSERTION_DEPENDENCIESdisplays the dependencies between assertions owned by the current user and the objects they reference. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the assertion | |
ASSERTION_NAME |
VARCHAR2(128) |
Name of the assertion | |
REFERENCED_OWNER |
VARCHAR2(128) |
Owner of the referenced object | |
REFERENCED_NAME |
VARCHAR2(128) |
Name of the referenced object | |
REFERENCED_TYPE |
VARCHAR2(23) |
Type of the referenced object | |
REFERENCED_ID |
NUMBER |
NOT NULL |
Unique identifier for the referenced object |
VALIDATION_TYPE |
VARCHAR2(8) |
Type of validation for the referenced object (FAST or COMPLETE) |
|
VALIDATION_EVENT |
VARCHAR2(24) |
Event on the referenced object that triggers the validation |
Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.1.
See Also: