Solved

delete queues from oracle 10g db

Posted on 2009-05-11
4
533 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
  • 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

Save on storage to protect fatherhood memories

You're the dad who has everything. This Father's Day, make sure your family memories are protected. My Passport Ultra has automatic backup and password protection to keep your cherished photos and videos safe. With up to 3TB, you have plenty of room to hold the adventures ahead.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Use of TCL script on Cisco devices:  - create file and merge it with running configuration to apply configuration changes
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now