Administrative Interface: Views, 4 of 16

Oracle8i Application Developer's Guide - Advanced Queuing
Release 2 (8.1.6)
Part Number A76938-01

Administrative Interface: Views, 4 of 16

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`		`VARCHAR`2(22)
`RECIPIENTS -- SINGLE or MULTIPLE recipient queue`		`VARCHAR2(8)`
`MESSAGE_GROUPING -- NONE or TRANSACTIONAL`		`VARCHAR`2(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)`

Oracle

Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.