7.74 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 |
|
|
|
Source AQ classic queue name |
|
|
Source AQ classic queue table name |
|
|
|
|
Target schema name |
|
|
|
Target TxEventQ name |
|
|
|
Migration event status |
|
|
|
Migration event |
|
|
Date and time at which the migration event occurred |
|
|
|
|
Migration event error comments, if any |
|
|
|
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 Database 23ai.
See Also: