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: