delete queues from oracle 10g db

Hi I'm new to Oracle...very new. Just need to know how to delete a queue. Is it just delete queue name or drop queue name. Thanks
SainaiAsked:
Who is Participating?
 
usachrisk1983Connect With a Mentor Commented:
This Experts-Exchange page goes over the commands as well as some useful comments:
http://www.experts-exchange.com/Database/Oracle/Q_22764918.html

Basically (from answer on other page):

begin
DBMS_AQADM.STOP_QUEUE('queuename');
   DBMS_AQADM.DROP_QUEUE('queuename');
   DBMS_AQADM.DROP_QUEUE_TABLE('queuetable name');
end;

Open in new window

0
 
SainaiAuthor Commented:
ok I logged in as sysdba and I typed the command to drop the queue and it says it does not recognize DBMS.
0
 
SainaiAuthor Commented:
sqlplus as the user/pw@cluster.
Then tried to sqlplus  / as sysdba but won't let me connect. Am I missing something?
Thanks
0
 
SainaiAuthor Commented:
also where do I go to see all the queues that are on my database?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.