OraFAQ Forum: Security » User management

Home » RDBMS Server » Security » User management (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User management [message #481433]

Wed, 03 November 2010 09:22

y_nitin
Messages: 3
Registered: November 2010
Location: Gurgaon

Junior Member

Can anyone please tell -

I'm trying to drop a user but it gives me below error message-

SQL> drop user <username> 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

However when i check from dba_queue_tables or user_queue_tables it doest show any queue tables

Report message to a moderator

Re: User management [message #481440 is a reply to message #481433]

Wed, 03 November 2010 09:32

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

http://decipherinfosys.wordpress.com/2007/05/16/resolving-ora-24005-when-dropping-a-schema-or-a-table/

Regards
Michel

Report message to a moderator

Re: User management [message #481441 is a reply to message #481440]

Wed, 03 November 2010 09:34

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

"How to Manually Cleanup Advanced Queuing Tables", Metalink note 203225.1

Regards
Michel

Report message to a moderator

Re: User management [message #481609 is a reply to message #481433]

Thu, 04 November 2010 09:54

y_nitin
Messages: 3
Registered: November 2010
Location: Gurgaon

Junior Member

Hi Michel,
Thanks for the prompt reply,

I already looked in that view and didnt found any queue table

"However when i check from dba_queue_tables or user_queue_tables it doest show any queue tables"

As of now ,i have found the solution.

Report message to a moderator