[Home] [Help] [Dependency Information]
Object Name: | DEF$_AQERROR |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00744 | NORMAL | UNIQUE | SYSTEM |
ENQ_TID
STEP_NO |
SYS_IL0000002563C00025$$ | LOB | UNIQUE | SYSTEM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
Q_NAME | VARCHAR2 | (30) | ||
MSGID | RAW | (16) | ||
CORRID | VARCHAR2 | (128) | ||
PRIORITY | NUMBER | |||
STATE | NUMBER | |||
DELAY | TIMESTAMP(6) | (11) | ||
EXPIRATION | NUMBER | |||
TIME_MANAGER_INFO | TIMESTAMP(6) | (11) | ||
LOCAL_ORDER_NO | NUMBER | |||
CHAIN_NO | NUMBER | |||
CSCN | NUMBER | |||
DSCN | NUMBER | |||
ENQ_TIME | TIMESTAMP(6) | (11) | ||
ENQ_UID | NUMBER | |||
ENQ_TID | VARCHAR2 | (30) | Yes | |
DEQ_TIME | TIMESTAMP(6) | (11) | ||
DEQ_UID | NUMBER | |||
DEQ_TID | VARCHAR2 | (30) | ||
RETRY_COUNT | NUMBER | |||
EXCEPTION_QSCHEMA | VARCHAR2 | (30) | ||
EXCEPTION_QUEUE | VARCHAR2 | (30) | ||
STEP_NO | NUMBER | Yes | ||
RECIPIENT_KEY | NUMBER | |||
DEQUEUE_MSGID | RAW | (16) | ||
USER_DATA | BLOB | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT Q_NAME
, MSGID
, CORRID
, PRIORITY
, STATE
, DELAY
, EXPIRATION
, TIME_MANAGER_INFO
, LOCAL_ORDER_NO
, CHAIN_NO
, CSCN
, DSCN
, ENQ_TIME
, ENQ_UID
, ENQ_TID
, DEQ_TIME
, DEQ_UID
, DEQ_TID
, RETRY_COUNT
, EXCEPTION_QSCHEMA
, EXCEPTION_QUEUE
, STEP_NO
, RECIPIENT_KEY
, DEQUEUE_MSGID
, USER_DATA
FROM SYSTEM.DEF$_AQERROR;
SYSTEM.DEF$_AQERROR does not reference any database object
SYSTEM.DEF$_AQERROR is referenced by following:
|
|
|