3.332 ALL_NOTIFICATION_DIRECTIVES

ALL_NOTIFICATION_DIRECTIVES describes the notification directives accessible to the current user.

You can join this view with the ALL_DIRECTIVES view to obtain additional details about notification directives.

Related Views

  • DBA_NOTIFICATION_DIRECTIVES describes all notification directives in the database.

  • USER_NOTIFICATION_DIRECTIVES describes the notification directives owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the notification directive

DIRECTIVE_NAME

VARCHAR2(128)

NOT NULL

Name of the notification directive

NOTIFICATION_TABLE

VARCHAR2(128)

NOT NULL

Notification table that tracks changes to the object

NOTIFICATION_VIEW

VARCHAR2(128)

NOT NULL

Notification view that tracks changes to the object

RETENTION

NUMBER

Retention time of the notification directive (in minutes)

NOTIFICATION_COLUMNS_CLAUSE

VARCHAR2(32767)

Columns clause of the notification directive

See Also: