eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYS.REG$

Object Details

Object Name:	REG$
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000000076C00010$$	LOB	UNIQUE	SYSTEM
REG$_IDX	NORMAL	NONUNIQUE	SYSTEM	SUBSCRIPTION_NAME NAMESPACE LOCATION_NAME REG_ID
REG$_T	NORMAL	NONUNIQUE	SYSTEM	TIMEOUT

Columns

Name	Datatype	Length	Mandatory
SUBSCRIPTION_NAME	VARCHAR2	(128)	Yes
LOCATION_NAME	VARCHAR2	(256)	Yes
USER#	NUMBER		Yes
USER_CONTEXT	RAW	(128)
CONTEXT_SIZE	NUMBER
NAMESPACE	NUMBER
PRESENTATION	NUMBER
VERSION	NUMBER
STATUS	NUMBER
ANY_CONTEXT	ANYDATA	(3748)
CONTEXT_TYPE	NUMBER
QOSFLAGS	NUMBER
PAYLOAD_CALLBACK	VARCHAR2	(4000)
TIMEOUT	TIMESTAMP(6)	(11)
REG_ID	NUMBER
REG_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)
NTFN_GROUPING_CLASS	NUMBER
NTFN_GROUPING_VALUE	NUMBER
NTFN_GROUPING_TYPE	NUMBER
NTFN_GROUPING_START_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)
NTFN_GROUPING_REPEAT_COUNT	NUMBER
GROUPING_INST_ID	NUMBER
STATE	NUMBER
SESSION_KEY	VARCHAR2	(1024)

Query Text

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


SELECT SUBSCRIPTION_NAME
,      LOCATION_NAME
,      USER#
,      USER_CONTEXT
,      CONTEXT_SIZE
,      NAMESPACE
,      PRESENTATION
,      VERSION
,      STATUS
,      ANY_CONTEXT
,      CONTEXT_TYPE
,      QOSFLAGS
,      PAYLOAD_CALLBACK
,      TIMEOUT
,      REG_ID
,      REG_TIME
,      NTFN_GROUPING_CLASS
,      NTFN_GROUPING_VALUE
,      NTFN_GROUPING_TYPE
,      NTFN_GROUPING_START_TIME
,      NTFN_GROUPING_REPEAT_COUNT
,      GROUPING_INST_ID
,      STATE
,      SESSION_KEY
FROM SYS.REG$;

Dependencies

[top of page]

SYS.REG$ references the following:

SYS: ANYDATA; STANDARD - show dependent code

SYS.REG$ is referenced by following:

SYS: DBA_SUBSCR_REGISTRATIONS; DBMS_CLIENT_RESULT_CACHE - show dependent code; USER_SUBSCR_REGISTRATIONS; _DBA_STREAMS_MSG_NOTIFICATIONS