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

VIEW: SYS.USER_CHANGE_NOTIFICATION_REGS

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

change notification registrations for current user

[View Source]

Columns
Name Datatype Length Mandatory Comments
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 REGID
,      REGFLAGS
,      CALLBACK
,      OPERATIONS_FILTER
,      CHANGELAG
,      TIMEOUT
,      TABLE_NAME
FROM SYS.USER_CHANGE_NOTIFICATION_REGS;

Dependencies

[top of page]

SYS.USER_CHANGE_NOTIFICATION_REGS references the following:

SchemaSYS
ViewDBA_CHANGE_NOTIFICATION_REGS
TableUSER$
SYS.USER_CHANGE_NOTIFICATION_REGS is referenced by following:

SchemaPUBLIC
SynonymUSER_CHANGE_NOTIFICATION_REGS
SchemaSYS
ViewUSER_CQ_NOTIFICATION_QUERIES