ORA-25607
cannot execute string migration because string is not empty. You can use PURGE_QUEUE_MESSAGES API
Cause
The queue was not empty.
Action
Either consume messages in the queue using dequeue API or use PURGE_QUEUE_MESSAGES API to drain the messages.