DBA_CHANGE_NOTIFICATION_REGS describes all change notification registrations in the database.
Related View: 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 |
No comments:
Post a Comment