[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1501
  • Last Modified:

Drop table

I am trying to drop all objects owned by a schema called "edmsdev". Everything is dropped except one table. I get the below error whne trying to drop this table

SQL> drop table FEED_QTBL;
drop table FEED_QTBL
           *
ERROR at line 1:
ORA-24005: Inappropriate utilities used to perform DDL on AQ table
EDMSDEV.FEED_QTBL


Can you please let me know how to resolve this. I have alraedy tried

SQL> drop DBMS_AQADM.DROP_QUEUE_TABLE FEED_QTBL;
drop DBMS_AQADM.DROP_QUEUE_TABLE FEED_QTBL
     *
ERROR at line 1:
ORA-00950: invalid DROP option
0
ank5
Asked:
ank5
1 Solution
 
jaisamCommented:
Are you using DB2?
0
 
slightwv (䄆 Netminder) Commented:
Not familiar with that exact package but try:

exec DBMS_AQADM.DROP_QUEUE_TABLE('FEED_QTBL');
0
 
Swadhin RaySenior Technical Engineer Commented:
Check if that is a table or other objects:

try to run this and check :


SQL> SELECT owner,
  object_name,
  object_type,
a.*
from all_objects a
WHERE object_name ='<<OBJECT NAME>>';

did you checked with cascade :

SQL> drop table FEED_QTBL cascade ;
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
slightwv (䄆 Netminder) Commented:
slobaray,

Did you look up that error message?  You cannot drop that table with a DROP command.

http://ora-24005.ora-code.com/
0
 
Swadhin RaySenior Technical Engineer Commented:
@ank5 :

Try to purge your recyclebin and check again if you still see the table..
0
 
slightwv (䄆 Netminder) Commented:
slobaray,
purging the recycle bin won't help.

re http:#a37001700


0
 
ank5Author Commented:
Thanks everyone, will try and get back today
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

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