Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_QUEUE_TABLES

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

Related Views

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: