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 of the queue table |
|
|
|
Name of the queue table |
|
|
|
Type of user data:
|
|
|
|
Object type of the payload when |
|
|
|
User-specified sort order |
|
|
|
|
|
|
|
|
|
|
|
Lowest release level which the queue table is compatible with (for example, |
|
|
|
Indicates the instance number of the instance which is the primary owner of the queue table. A value of |
|
|
|
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 |
|
|
|
Instance number of the instance which currently owns the queue table |
|
|
|
Comment supplied by the user |
|
|
|
Indicates whether the queue table is secure ( |
See Also:
Oracle Database Advanced Queuing User's Guide for more information Advanced Queuing