ALL_ASSERTIONS

ALL_ASSERTIONS displays assertions accessible to the current user.

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_ASSERTIONS displays all assertions in the database.

• USER_ASSERTIONS displays assertions owned by the current user. 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
OBJECT_ID	NUMBER	NOT NULL	Object ID number of the assertion You can join this column with the OBJECT_ID column of the ALL_OBJECTS view to obtain more details about the object.
STATUS	VARCHAR2(8)		Indicates whether the assertion is enfoced during execution of DML statements (ENABLED) or not (DISABLED)
DEFERRABLE	VARCHAR2(14)		Indicates whether the assertion is DEFERRABLE or NOT DEFERRABLE
DEFERRED	VARCHAR2(9)		Indicates whether the assertion is deferred by default (DEFERRED) or not (IMMEDIATE)
VALIDATED	VARCHAR2(13)		Indicates whether the database has validated that data in the involved tables of the assertion obeys the assertion (VALIDATED) or not (NOT VALIDATED)
INVALID	VARCHAR2(7)		Reserved for internal use
DEFINITION_SQL	CLOB		SQL text of the assertion definition If the assertion is not owned by the current user, the value of this column is null.

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.1.

See Also:

• “DBA_ASSERTIONS”

• “USER_ASSERTIONS”

• “ALL_OBJECTS”