DBA_CHANGE_NOTIFICATION_REGS describes all change notification registrations for the database.

Related View

USER_CHANGE_NOTIFICATION_REGS describes change notification registrations for current user. This view does not display the USERNAME column.

Column Datatype NULL Description
USERNAME VARCHAR2(31)   Owner of the registration
REGID NUMBER   Internal registration ID
REGFLAGS NUMBER   Registration flags
CALLBACK VARCHAR2(63)   Notification callback
OPERATIONS_FILTER NUMBER   Operations filter (if specified)
CHANGELAG NUMBER   Transaction lag between notifications (if specified)
TIMEOUT NUMBER   Registration timeout (if specified)
TABLE_NAME VARCHAR2(63)   Name of registered table