Oracle AQ: start a queue
September 11, 2008 23:14:18 Last update: September 11, 2008 23:14:29
Use the
dbms_aqadm PL/SQL package to start a queue:
-- Start a queue and enable both enqueue and dequeue EXECUTE dbms_aqadm.start_queue ( queue_name => 'msg_queue'); -- Start a previously stopped queue for dequeue only EXECUTE dbms_aqadm.start_queue ( queue_name => 'msg_queue', dequeue => TRUE, enqueue => FALSE); -- Start enqueue after dequeue also EXECUTE dbms_aqadm.start_queue ( queue_name => 'msg_queue', dequeue => FALSE, -- dequeue won't be stopped even if this is FALSE enqueue => TRUE);
Easy email testing with http://www.ximailstop.com