I would like to transfer the enqueued messages to a backup table after they have been dequeued.
Currently we are using
DBMS_AQ.DEQUEUE with mode
dequeue_mode := DBMS_AQ.REMOVE.
So after the message gets dequeued, the queue table does not keep any entry. But we need the message in a backup table once dequeued, so that we can check the backup table for debugging purposes.
If I use browse mode, would it help ? Are there any other alternatives?
I am using Oracle 11g.