Administrative Interface: Views, 10 of 16

Select Queue Tables in User Schema

Figure 10-9 Use Case Diagram: Select Queue Tables in User Schema

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:

USER_QUEUE_TABLES

Syntax:

This view is the same as DBA_QUEUE_TABLES with the exception that it only shows queue tables in the user's schema. It does not contain a column for OWNER.

Table 10-9 USER_QUEUE_TABLES

Column Name & Description	Null?	Type
`QUEUE_TABLE - queue table name`		`VARCHAR2(30)`
`TYPE -- payload type`		`VARCHAR2(7)`
`OBJECT_TYPE -- name of object type, if any`		`VARCHAR2(61)`
`SORT_ORDER -- user specified sort order`		`VARCHAR2(22)`
`RECIPIENTS -- SINGLE or MULTIPLE`		`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)`