• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 547
  • Last Modified:

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
0
Sainai
Asked:
Sainai
  • 3
1 Solution
 
usachrisk1983Commented:
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

Featured Post

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now