Selecting User Queue Tables

Figure 10-3 Use Case Diagram: Select User Queue Tables

Text description of the illustration adq10qvw6.gif

Name of View

ALL_QUEUE_TABLES

Purpose

This view describes queue tables accessible to a user.

Table 10-3  DBA_QUEUE_TABLES

Column Name & Description	Null?	Type
OWNER--owner of the queue table		VARCHAR2(30)
QUEUE_TABLE--queue table name		VARCHAR2(30)
TYPE--payload type		VARCHAR2(7)
OBJECT_TYPE--object type, if any		VARCHAR2(61)
SORT_ORDER--user-specified sort order		VARCHAR2(22)
RECIPIENTS--SINGLE or MULTIPLE recipient queue		VARCHAR2(8)
MESSAGE_GROUPING--NONE or TRANSACTIONAL		VARCHAR2(13)
COMPATIBLE--indicates the lowest version with which the queue table is compatible		VARCHAR2(5)
PRIMARY_INSTANCE--indicates which instance is the primary owner of the queue table; a value of 0 indicates that there is no primary owner		NUMBER
SECONDARY_INSTANCE--indicates which owner is the secondary owner of the queue table; this instance becomes the owner of the queue table if the primary owner is not up; a value of 0 indicates that there is no secondary owner		NUMBER
OWNER_INSTANCE--indicates which instance currently owns the queue table		NUMBER
USER_COMMENT--user comment for the queue table		VARCHAR2(50)