[Home] [Help] [Dependency Information]
Object Name: | CDB_QUEUE_TABLES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All queue tables created in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Owner of the queue table | |
QUEUE_TABLE | VARCHAR2 | (128) | Name of the queue table | |
TYPE | VARCHAR2 | (7) | Name of the payload type | |
OBJECT_TYPE | VARCHAR2 | (61) | Name of the payload type for object type payload | |
SORT_ORDER | VARCHAR2 | (22) | Sort order for the queue table | |
RECIPIENTS | VARCHAR2 | (8) | Mulitple or single recipient queue | |
MESSAGE_GROUPING | VARCHAR2 | (13) | Transaction grouping | |
COMPATIBLE | VARCHAR2 | (6) | Compatibility version of the queue table | |
PRIMARY_INSTANCE | NUMBER | Instance assigned as the primary owner of the queue table | ||
SECONDARY_INSTANCE | NUMBER | Instance assigned as the secondary owner of the queue table | ||
OWNER_INSTANCE | NUMBER | Instance which owns the queue table currently | ||
USER_COMMENT | VARCHAR2 | (50) | User specified comment | |
SECURE | VARCHAR2 | (3) | Secure queue table | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, QUEUE_TABLE
, TYPE
, OBJECT_TYPE
, SORT_ORDER
, RECIPIENTS
, MESSAGE_GROUPING
, COMPATIBLE
, PRIMARY_INSTANCE
, SECONDARY_INSTANCE
, OWNER_INSTANCE
, USER_COMMENT
, SECURE
, CON_ID
FROM SYS.CDB_QUEUE_TABLES;
SYS.CDB_QUEUE_TABLES does not reference any database object
SYS.CDB_QUEUE_TABLES is referenced by following:
|
|
|