Solved

delete queues from oracle 10g db

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle DB Slows After Datapump Until Next Reboot 27 122
Access 2016 Query with Proper Case logic 2 48
Switch port problems 15 28
Star schema daily updates 2 33
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

685 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