KUPC$* Oracle Creates Queues(service names) During using datapump. service_names should clean up after data pump finished. http://surachartopun.com/2009/11/datapump-with-syssys-servicenames.html About Queue Name -> I don't see queue (old date) in QUEUE_TABLE table. Good Luck Surachart Opun http://surachartopun.com On Sat, Feb 20, 2010 at 9:34 PM, LS Cheng <exriscer@xxxxxxxxx> wrote: > 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 > >