Select User Queue Tables

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

To refer to the table of all basic operations having to do with the Operational Interface see: "Use Case Model: Administrative Interface -- Views"

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)