2 Replies Latest reply: Jul 3, 2013 7:49 AM by 929255 RSS

    Re enable dequeueing for expired messages in AQ

    929255

      Dear all,

       

      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:

      BEGIN
        SYS.DBMS_AQADM.CREATE_QUEUE
        (
          QUEUE_NAME          =>   'CC.PMTS'
         ,QUEUE_TABLE         =>   'CC.PMTS_DATA'
         ,QUEUE_TYPE          =>   SYS.DBMS_AQADM.NORMAL_QUEUE
         ,MAX_RETRIES         =>   0
         ,RETRY_DELAY         =>   0
         ,RETENTION_TIME      =>   0
         ,COMMENT             =>   'Comment'
         );
      END;
      
      

      Thanks