Oracle AQ: start a queue 

Joined:
04/09/2007
Posts:
703

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);
Share |
| Comment  | Tags
 
Easy email testing with http://www.ximailstop.com