Oracle Error ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

Oracle Error Message

ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

Reason for the Error

An attempt was made to downgrade the queue table when there were messages being propagated that were in the prepared state.

Solution

Wait for the propagation to complete before retrying the operation.