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

TABLE: SYS.AQ$_PROPAGATION_STATUS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: AQ$_PROPAGATION_STATUS_PRIMARY
  1. ColumnQUEUE_ID
  2. ColumnDESTINATION
  3. ColumnDESTQUEUE_ID
Indexes
Index Type Uniqueness Tablespace Column
AQ$_PROPAGATION_STATUS_PRIMARY NORMAL UNIQUE TablespaceSYSTEM ColumnQUEUE_ID
ColumnDESTINATION
ColumnDESTQUEUE_ID
Columns
Name Datatype Length Mandatory Comments
QUEUE_ID NUMBER
Yes
DESTINATION VARCHAR2 (128) Yes
SEQUENCE NUMBER

STATUS NUMBER

TXNID VARCHAR2 (22)
DESTQUEUE_ID NUMBER
Yes
FLAGS NUMBER

Query Text

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


SELECT QUEUE_ID
,      DESTINATION
,      SEQUENCE
,      STATUS
,      TXNID
,      DESTQUEUE_ID
,      FLAGS
FROM SYS.AQ$_PROPAGATION_STATUS;

Dependencies

[top of page]

SYS.AQ$_PROPAGATION_STATUS does not reference any database object

SYS.AQ$_PROPAGATION_STATUS is referenced by following:

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