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

TABLE: SYS.AQ$_ALERT_QT_T

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

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_366153
  1. ColumnNEXT_DATE
  2. ColumnTXN_ID
  3. ColumnMSGID
Indexes
Index Type Uniqueness Tablespace Column
SYS_IOT_TOP_366153 IOT - TOP UNIQUE TablespaceSYSAUX ColumnNEXT_DATE
ColumnTXN_ID
ColumnMSGID
Columns
Name Datatype Length Mandatory Comments
NEXT_DATE TIMESTAMP(6) (11) Yes
TXN_ID VARCHAR2 (30) Yes
MSGID RAW (16) Yes
ACTION NUMBER

Query Text

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


SELECT NEXT_DATE
,      TXN_ID
,      MSGID
,      ACTION
FROM SYS.AQ$_ALERT_QT_T;

Dependencies

[top of page]

SYS.AQ$_ALERT_QT_T does not reference any database object

SYS.AQ$_ALERT_QT_T is referenced by following:

SchemaSYS
QueueALERT_QUE
QueueAQ$_ALERT_QT_E