Administrative Interface: Views, 3 of 16

Select All Queue Tables in Database

To refer to the table of all basic operations having to do with the Operational Interface see:

"Use Case Model: Administrative Interface -- Views"

DBA_QUEUE_TABLES

This view describes the names and types of all queue tables created in the database.

Column Name & Description	Null?	Type
`OWNER -- queue table schema`		`VARCHAR2(30)`
`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`		`VARCHAR`2(22)
`RECIPIENTS -- SINGLE or MULTIPLE`		`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)`