ALL_QUEUE_TABLES

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

Related Views

DBA_QUEUE_TABLES describes queues in all queue tables in the database.

USER_QUEUE_TABLES describes 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 this 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.