DBA_CHANGE_NOTIFICATION_REGS

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	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