DBA_CHANGE_NOTIFICATION_REGS describes all change notification registrations in the database.
USER_CHANGE_NOTIFICATION_REGS describes the change notification registrations owned by the 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(256) |
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 the registered table |
See Also:
"USER_CHANGE_NOTIFICATION_REGS"