3.85 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_DEPENDENCIES displays the dependencies between all assertions in the database and the objects they reference.

  • USER_ASSERTION_DEPENDENCIES displays the dependencies between assertions owned by the current user and the objects they reference. This view does not display the OWNER column.

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: