I tried to perform 'Move' but I must be doing sth wrong.
I need to reprocess expired messages in an advanced queue.
Is there a script that allows either to retry dequeuing or to re insert/enqueue again the messages?
The creation script of the queue follows:
Well, yes, that's what the MAX_RETRIES and RETRY_DELAY does:
BEGIN SYS.DBMS_AQADM.CREATE_QUEUE ( QUEUE_NAME => 'CC.PMTS' ,QUEUE_TABLE => 'CC.PMTS_DATA' ,QUEUE_TYPE => SYS.DBMS_AQADM.NORMAL_QUEUE ,MAX_RETRIES => 6 ,RETRY_DELAY => 10 ,RETENTION_TIME => 0 ,COMMENT => 'Comment' ); END;
There, that will retry the item 6 times, with a 10s delay between each retry. (Note: I haven't verified the time, but if memory serves correctly, it is by seconds)
My problem is that the messages are expired and I want to reprocess them. Not how to configure the queue.
Oh, then just go fetch it from the expired queue, and re-queue it. I don't think there's a given script just :
1) retrieve record/item from expired queue.
2) re-queue it to your main queue.