4.148 ALL_TXEVENTQ_MIGRATION_STATUS

ALL_TXEVENTQ_MIGRATION_STATUS provides information about migrations from AQ classic queues to Transactional Event Queues (TxEventQs) accessible to the current user.

Related Views

• DBA_TXEVENTQ_MIGRATION_STATUS provides information about all migrations from AQ classic queues to Transactional Event Queues (TxEventQs). This view also displays the SUFFIX column.

• USER_TXEVENTQ_MIGRATION_STATUS provides information about migrations from AQ classic queues to Transactional Event Queues (TxEventQs) owned by the current user. This view does not display the SOURCE_SCHEMA_NAME and SUFFIX columns.

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 record/event type: 0 - This row displays data about unsupported features captured via a migration API 1 - This row displays specific migration API details that the user executed 2 - This row displays data about unsupported features captured as warnings
EVENT	VARCHAR2(128)		Migration event. Possible values include: Retry Delay Message Grouping Listen Next Message
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

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_TXEVENTQ_MIGRATION_STATUS"

• "USER_TXEVENTQ_MIGRATION_STATUS"