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

TABLE: SYS.AQ$_MESSAGE_TYPES

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: AQ$_MSGTYPES_UNIQUE
  1. ColumnQUEUE_OID
  2. ColumnSCHEMA_NAME
  3. ColumnQUEUE_NAME
  4. ColumnDESTINATION
  5. ColumnTRANS_NAME
Indexes
Index Type Uniqueness Tablespace Column
AQ$_MSGTYPES_UNIQUE NORMAL UNIQUE TablespaceSYSTEM ColumnQUEUE_OID
ColumnSCHEMA_NAME
ColumnQUEUE_NAME
ColumnDESTINATION
ColumnTRANS_NAME
Columns
Name Datatype Length Mandatory Comments
QUEUE_OID RAW (16) Yes
SCHEMA_NAME VARCHAR2 (128) Yes
QUEUE_NAME VARCHAR2 (128) Yes
DESTINATION VARCHAR2 (128) Yes
TOID RAW (16)
VERSION NUMBER

VERIFIED VARCHAR2 (1)
PROPERTIES NUMBER

TRANS_NAME VARCHAR2 (257)
NETWORK_NAME VARCHAR2 (256)
Query Text

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


SELECT QUEUE_OID
,      SCHEMA_NAME
,      QUEUE_NAME
,      DESTINATION
,      TOID
,      VERSION
,      VERIFIED
,      PROPERTIES
,      TRANS_NAME
,      NETWORK_NAME
FROM SYS.AQ$_MESSAGE_TYPES;

Dependencies

[top of page]

SYS.AQ$_MESSAGE_TYPES does not reference any database object

SYS.AQ$_MESSAGE_TYPES is referenced by following:

SchemaSYS
Package BodyDBMS_AQADM_SYS - show dependent code
Package BodyDBMS_PRVTAQIP - show dependent code