Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can't drop user doe to non-extant que table

stevepenceFeb 1 2008 — edited Feb 1 2008
I'm in a pickle!
SQL> drop user utl cascade;
drop user utl cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables


SQL> select * from dba_queue_tables where owner = 'UTL';

no rows selected

Looking through dba_queues and dba_queue_tables I see nothing related to this user. How can I find the offending opbject?

Thanks
Steve
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 29 2008
Added on Feb 1 2008
2 comments
1,937 views