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 theOWNER
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 |
|
|
|
|
|
|
|
|
|
|
|
Indicates whether the queue tables are enabled for replication through Oracle GoldenGate. If the queue tables are replicated, these values appear in the column:
If replication is not enabled on the queue tables, then this column is empty. |
|
|
|
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