3.21 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(128)		Owner of the queue table
QUEUE_TABLE	VARCHAR2(128)		Name of the queue table
TYPE	VARCHAR2(9)		Type of user data: RAW - Raw type OBJECT - User-defined object type VARIANT - Variant type (for internal use only)
OBJECT_TYPE	VARCHAR2(257)		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
REPLICATION_MODE	VARCHAR2(22)		Indicates whether the queue tables are enabled for replication through Oracle GoldenGate. If the queue tables are replicated, these values appear in the column: REPLICATED_SOURCE: This value is displayed for a source queue table. REPLICATED_DESTINATION: This value is displayed for a destination queue table. If replication is not enabled on the queue tables, then this column is empty.
COMPATIBLE	VARCHAR2(6)		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"

• Oracle Database Advanced Queuing User's Guide for more information Advanced Queuing