Sunday, November 17, 2013

How to purge Oracle AQ

How to purge Oracle AQ


Please execute following SQL query ==>
DECLARE
po_t dbms_aqadm.aq$_purge_options_t;
BEGIN
  DBMS_AQADM.PURGE_QUEUE_TABLE('username.PURCHASE_QUEUE_TABLE', NULL, PO_T);
END;