DBA_TXEVENTQ_MIGRATION

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`	`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 Database 23ai.