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

VIEW: SYS.CDB_CHANGE_NOTIFICATION_REGS

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

Description of the registrations for change notification in all containers

[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
CON_ID NUMBER

container id
Query Text

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


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

Dependencies

[top of page]

SYS.CDB_CHANGE_NOTIFICATION_REGS does not reference any database object

SYS.CDB_CHANGE_NOTIFICATION_REGS is referenced by following:

SchemaPUBLIC
SynonymCDB_CHANGE_NOTIFICATION_REGS