ALL_QUEUE_TABLES v10

The ALL_QUEUE_TABLES view provides information about all of the queue tables in the database.

NameTypeDescription
ownerTEXTRole name of the owner of the queue table.
queue_tableTEXTThe user-specified name of the queue table.
typeCHARACTER VARYINGThe type of data stored in the queue table.
object_typeTEXTThe user-defined payload type.
sort_orderCHARACTER VARYINGThe order in which the queue table is sorted.
recipientsCHARACTER VARYINGAlways SINGLE.
message_groupingCHARACTER VARYINGAlways NONE.
compatibleCHARACTER VARYINGThe release number of the Advanced Server release with which this queue table is compatible.
primary_instanceNUMERICAlways 0.
secondary_instanceNUMERICAlways 0.
owner_instanceNUMERICThe instance number of the instance that owns the queue table.
user_commentCHARACTER VARYINGThe user comment provided when the table was created.
secureCHARACTER VARYINGYES indicates that the queue table is secure; NO indicates that it is not.