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

TABLE: SYS.AQ$_SUBSCRIBER_TABLE

Object Details
Object Name: AQ$_SUBSCRIBER_TABLE
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: AQ$_SUBSCRIBER_TABLE_PRIMARY
  1. ColumnTABLE_OBJNO
  2. ColumnSUBSCRIBER_ID
Indexes
Index Type Uniqueness Tablespace Column
AQ$_SUBSCRIBER_TABLE_PRIMARY NORMAL UNIQUE TablespaceSYSTEM ColumnTABLE_OBJNO
ColumnSUBSCRIBER_ID
AQ$_SUBSCRIBER_TABLE_I NORMAL NONUNIQUE TablespaceSYSTEM ColumnSUBSCRIBER_TYPE
Columns
Name Datatype Length Mandatory Comments
SCHEMA VARCHAR2 (128) Yes
TABLE_NAME VARCHAR2 (128) Yes
TABLE_OBJNO NUMBER
Yes
QUEUE_ID NUMBER
Yes
SUBSCRIBER_ID NUMBER
Yes
QUEUE_NAME VARCHAR2 (128) Yes
NAME VARCHAR2 (128)
ADDRESS VARCHAR2 (1024)
PROTOCOL NUMBER

SUBSCRIBER_TYPE NUMBER

RULE_NAME VARCHAR2 (128)
TRANS_NAME VARCHAR2 (261)
RULESET_NAME VARCHAR2 (261)
NEGATIVE_RULESET_NAME VARCHAR2 (261)
CREATION_TIME TIMESTAMP(6) WITH TIME ZONE (13)
MODIFICATION_TIME TIMESTAMP(6) WITH TIME ZONE (13)
DELETION_TIME TIMESTAMP(6) WITH TIME ZONE (13)
SCN_AT_REMOVE NUMBER

SCN_AT_ADD NUMBER

CLIENT_SESSION_GUID VARCHAR2 (36)
INSTANCE_ID NUMBER

Query Text

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


SELECT SCHEMA
,      TABLE_NAME
,      TABLE_OBJNO
,      QUEUE_ID
,      SUBSCRIBER_ID
,      QUEUE_NAME
,      NAME
,      ADDRESS
,      PROTOCOL
,      SUBSCRIBER_TYPE
,      RULE_NAME
,      TRANS_NAME
,      RULESET_NAME
,      NEGATIVE_RULESET_NAME
,      CREATION_TIME
,      MODIFICATION_TIME
,      DELETION_TIME
,      SCN_AT_REMOVE
,      SCN_AT_ADD
,      CLIENT_SESSION_GUID
,      INSTANCE_ID
FROM SYS.AQ$_SUBSCRIBER_TABLE;

Dependencies

[top of page]

SYS.AQ$_SUBSCRIBER_TABLE does not reference any database object

SYS.AQ$_SUBSCRIBER_TABLE is referenced by following:

SchemaSYS
Package BodyDBMS_AQADM_SYS - show dependent code