Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

delete queues from oracle 10g db

Posted on 2009-05-11
4
Medium Priority
?
541 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 150 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

670 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