DBA_TXEVENTQ_MIGRATION_STATUS
DBA_TXEVENTQ_MIGRATION_STATUS provides information about all migrations from AQ classic queues to Transactional Event Queues (TxEventQs).
Its columns (except for SUFFIX) are the same as those in ALL_TXEVENTQ_MIGRATION_STATUS.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SOURCE_SCHEMA_NAME |
VARCHAR2(128) |
NOT NULL |
Source schema name |
SOURCE_QUEUE_NAME |
VARCHAR2(128) |
NOT NULL |
Source AQ classic queue name |
SOURCE_QUEUE_TABLE |
VARCHAR2(128) |
Source AQ classic queue table name | |
TARGET_SCHEMA_NAME |
VARCHAR2(128) |
NOT NULL |
Target schema name |
TARGET_QUEUE_NAME |
VARCHAR2(128) |
NOT NULL |
Target TxEventQ name |
EVENT_STATUS |
NUMBER |
Migration event status | |
EVENT |
VARCHAR2(128) |
Migration event | |
EVENT_TIMESTAMP |
TIMESTAMP (6) WITH TIME ZONE |
Date and time at which the migration event occurred | |
EVENT_ERROR_COMMENTS |
VARCHAR2(1024) |
Migration event error comments, if any | |
SUFFIX |
VARCHAR2(2) |
Temporary TxEventQ name suffix, if any This suffix is supplied by the user to avoid name conflicts during the migration. |
Note: This view is available starting with Oracle AI Database 26ai.
See Also: “ALL_TXEVENTQ_MIGRATION_STATUS”