Cleanup Data Pump queues

From: LS Cheng <exriscer_at_gmail.com>
Date: Sat, 20 Feb 2010 15:34:06 +0100
Message-ID: <6e9345581002200634r32686430y780cbb5799b79a3e_at_mail.gmail.com>



Hi

From time to time some of my data pump jobs generate queues which are not cleanup after some sort of errors or manual abort. This generate some funny service names such as SYS$SYS.KUPC$C_1_20100220091129.ONLINE. Sort of annoying although not critical.

I have been cleanup the queues using this steps:

SQL> exec dbms_aqadm.stop_queue('KUPC$C_1_20100220091129') PL/SQL procedure successfully completed.

SQL> exec dbms_aqadm.stop_queue('KUPC$S_1_20100220091129') PL/SQL procedure successfully completed.

SQL> exec dbms_aqadm.drop_queue('KUPC$C_1_20100220091129') PL/SQL procedure successfully completed.

SQL> exec dbms_aqadm.drop_queue('KUPC$S_1_20100220091129') PL/SQL procedure successfully completed.

It works but is this correct? Because I cannot find much information on MOS about cleaning up these queues.

TIA
--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Sat Feb 20 2010 - 08:34:06 CST

Original text of this message