[Home] [Help] [Dependency Information]
Object Name: | ECX_OUTQUEUE |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00219662 | NORMAL | UNIQUE | APPS_TS_TX_DATA | MSGID |
SYS_IL0000412612C00041$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000412612C00047$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
AQ$_ECX_OUTQUEUE_I | NORMAL | NONUNIQUE | APPS_TS_TX_DATA |
Q_NAME
STATE ENQ_TIME STEP_NO CHAIN_NO LOCAL_ORDER_NO |
AQ$_ECX_OUTQUEUE_T | NORMAL | NONUNIQUE | APPS_TS_TX_DATA | TIME_MANAGER_INFO |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
Q_NAME | VARCHAR2 | (30) | ||
MSGID | RAW | (16) | Yes | |
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) | ||
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 | |||
RECIPIENT_KEY | NUMBER | |||
DEQUEUE_MSGID | RAW | (16) | ||
SENDER_NAME | VARCHAR2 | (30) | ||
SENDER_ADDRESS | VARCHAR2 | (1024) | ||
SENDER_PROTOCOL | NUMBER | |||
USER_DATA | ECXMSG | (1) | ||
USER_PROP | ANYDATA | (3752) |
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
, SENDER_NAME
, SENDER_ADDRESS
, SENDER_PROTOCOL
, USER_DATA
, USER_PROP
FROM APPLSYS.ECX_OUTQUEUE;
|
|
|