ALL_QUEUE_TABLES

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

Related Views

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

  Column	Datatype	NULL	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)		Lowest release level which the queue table is compatible with (for example, 8.0.3)
  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		Instance number of the instance which currently owns the queue table
  USER_COMMENT	VARCHAR2(50)		Comment supplied by the user
  SECURE	VARCHAR2(3)		Indicates whether the queue table is secure (YES) or not (NO)

  See Also: "DBA_QUEUE_TABLES" "USER_QUEUE_TABLES" Oracle9i Application Developer's Guide - Advanced Queuing for more information about these views and Advanced Queuing