Location: Rules of Conduct

Discussion: ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tablesReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 2 posts

nisahu77
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
Jul 17 2008, 11:25 AM EDT | Post edited: Jul 17 2008, 11:25 AM EDT
Hi,

I am getting following error when I am trying to drop the users with cascade command (As given Below)
SQL> drop user sa cascade;
drop user sa 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

I logged in by sa user and ran the following command to check queue tables

SQL> select * from user_queue_tables;

no rows selected

I want to drop sa user. I have checked the note 203225.1 but that couldn’t help to resolve the issue. Can you please help to resolve the issues urgently?

Thanks & Regards
Nilesh Sahu
 4  out of 8 found this valuable. Do you?    
Keyword tags: ORA-24005

nisahu77
1. RE: ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
Jul 17 2008, 11:26 AM EDT | Post edited: Jul 17 2008, 11:26 AM EDT
I am using following Oracle version:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production 6  out of 9 found this valuable. Do you?