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: