Solved

delete queues from oracle 10g db

Posted on 2009-05-11
4
540 Views
Last Modified: 2013-12-18
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
0
Comment
Question by:Sainai
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 13

Accepted Solution

by:
usachrisk1983 earned 50 total points
ID: 24353037
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
 

Author Comment

by:Sainai
ID: 24354623
ok I logged in as sysdba and I typed the command to drop the queue and it says it does not recognize DBMS.
0
 

Author Comment

by:Sainai
ID: 24354655
sqlplus as the user/pw@cluster.
Then tried to sqlplus  / as sysdba but won't let me connect. Am I missing something?
Thanks
0
 

Author Comment

by:Sainai
ID: 24354724
also where do I go to see all the queues that are on my database?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use of TCL script on Cisco devices:  - create file and merge it with running configuration to apply configuration changes
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question