OWNER -- owner of the queue table |
|
VARCHAR2(30) |
QUEUE_TABLE - queue table name |
|
VARCHAR2(30) |
TYPE -- payload type |
|
VARCHAR2(7) |
OBJECT_TYPE -- object type, if any |
|
VARCHAR2(61) |
SORT_ORDER -- user-specified sort order |
|
VARCHAR 2(22) |
RECIPIENTS -- SINGLE or MULTIPLE recipient queue |
|
VARCHAR2(8) |
MESSAGE_GROUPING -- NONE or TRANSACTIONAL |
|
VARCHAR 2(13) |
COMPATIBLE -- indicates the lowest version with which the queue table is compatible |
|
VARCHAR2(5) |
PRIMARY_INSTANCE -- indicates which instance is the primary owner of the queue table; a value of 0 indicates that there is no primary owner |
|
NUMBER |
SECONDARY_INSTANCE -- indicates which owner is the secondary owner of the queue table; this instance becomes the owner of the queue table if the primary owner is not up; a value of 0 indicates that there is no secondary owner |
|
NUMBER |
OWNER_INSTANCE -- indicates which instance currently owns the queue table |
|
NUMBER |
USER_COMMENT -- user comment for the queue table |
|
VARCHAR2(50) |