DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_CHANGE_NOTIFICATION_REGS

Object Details
Object Name: DBA_CHANGE_NOTIFICATION_REGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of the registrations for change notification

[View Source]

Columns
Name Datatype Length Mandatory Comments
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 registered table
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USERNAME
,      REGID
,      REGFLAGS
,      CALLBACK
,      OPERATIONS_FILTER
,      CHANGELAG
,      TIMEOUT
,      TABLE_NAME
FROM SYS.DBA_CHANGE_NOTIFICATION_REGS;

Dependencies

[top of page]

SYS.DBA_CHANGE_NOTIFICATION_REGS references the following:

SYS.DBA_CHANGE_NOTIFICATION_REGS is referenced by following:

SchemaPUBLIC
SynonymDBA_CHANGE_NOTIFICATION_REGS
SchemaSYS
ViewUSER_CHANGE_NOTIFICATION_REGS