Tuesday 17 April 2012

ORA-24018: STOP_QUEUE on string failed, outstanding transactions found

ORA-24018: STOP_QUEUE on string failed, outstanding transactions found

Cause: There were outstanding transactions on the queue, and WAIT was set to false, so STOP_QUEUE was unsucessful in stopping the queue.

Action: Set WAIT to TRUE and try STOP_QUEUE again. It will hang till all outstanding transactions are completed.

No comments:

Post a Comment