Static Data Dictionary Views, 66 of 452

ALL_QUEUE_TABLES

ALL_QUEUE_TABLES describes queues in all queue tables accessible to the current user.

USER_QUEUE_TABLES describes queues in queue tables created in the user's schema. This view does not display the OWNER column.

See Also:
Oracle8i Application Developer's Guide - Advanced Queuing for more information about these views and Advanced Queuing.

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Schema of the queue table
`QUEUE_TABLE`	`VARCHAR2(30)`	Name of the queue table
`TYPE`	`VARCHAR2(7)`	Type of user data: `RAW`: raw type `OBJECT`: user-defined object type `VARIANT`: variant type (internal use only)
`OBJECT_TYPE`	`VARCHAR2(61)`	Object type of the payload when `TYPE` is `OBJECT`
`SORT_ORDER`	`VARCHAR2(22)`	User specified sort order
`RECIPIENTS`	`VARCHAR2(8)`	`SINGLE` or `MULTIPLE` recipients
`MESSAGE_GROUPING`	`VARCHAR2(13)`	`NONE` or `TRANSACTIONAL`
`COMPATIBLE`	`VARCHAR2(5)`	The lowest release level which this is compatible with (eg, 8.0.4)
`PRIMARY_INSTANCE`	`NUMBER`	Indicates the instance number of the instance which is the primary owner of the queue table. A value of 0 indicates that there is no primary owner
`SECONDARY_INSTANCE`	`NUMBER`	Indicates the instance number of the instance which is the secondary owner of the queue table. This instance becomes the owner of the queue table if the primary owner is not alive. A value of 0 indicates that there is no secondary owner
`OWNER_INSTANCE`	`NUMBER`	The instance number of the instance which currently owns the queue table
`USER_COMMENT`	`VARCHAR2(50)`	Comment supplied by the user