dropping user..

Quote:

---

Originally posted by adewri
Why do you waste time, does it hurt to give more details like what Oracle version, what OS etc ???

---

WOW! How was your weekend?

:D

MH

Looks as though your are using Oracle Advanced queing.

does the user your are trying to drop own any queue tables?

select owner,queue_table,type from dba_queue_tables;

If this is the case then you must use the DBMS_AQADM.DROP_QUEUE_TABLE procedure.