[Home] [Help] [Dependency Information]
Object Name: | AQ$_DURABLE_SUBS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AQ$_DURABLE_SUBS_PRIMARY | NORMAL | UNIQUE | SYSTEM |
QUEUE_ID
SUBSCRIBER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEMA | VARCHAR2 | (30) | Yes | |
QUEUE_ID | NUMBER | Yes | ||
QUEUE_NAME | VARCHAR2 | (30) | Yes | |
TABLE_OBJNO | NUMBER | Yes | ||
SUBSCRIBER_ID | NUMBER | Yes | ||
NAME | VARCHAR2 | (4000) | ||
ADDRESS | VARCHAR2 | (1024) | ||
PROTOCOL | NUMBER | |||
SUBSCRIBER_TYPE | NUMBER | |||
POS_BITMAP | NUMBER | |||
RULE_NAME | VARCHAR2 | (30) | ||
TRANS_OWNER | VARCHAR2 | (30) | ||
TRANS_NAME | VARCHAR2 | (30) | ||
CREATION_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEMA
, QUEUE_ID
, QUEUE_NAME
, TABLE_OBJNO
, SUBSCRIBER_ID
, NAME
, ADDRESS
, PROTOCOL
, SUBSCRIBER_TYPE
, POS_BITMAP
, RULE_NAME
, TRANS_OWNER
, TRANS_NAME
, CREATION_TIME
FROM SYS.AQ$_DURABLE_SUBS;
SYS.AQ$_DURABLE_SUBS does not reference any database object
SYS.AQ$_DURABLE_SUBS is referenced by following:
|
|
|