Home » RDBMS Server » Security » User management (10.2.0.4)
User management [message #481433] Wed, 03 November 2010 09:22 Go to next message
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
Re: User management [message #481440 is a reply to message #481433] Wed, 03 November 2010 09:32 Go to previous messageGo to next message
Michel Cadot
Messages: 57599
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
Re: User management [message #481441 is a reply to message #481440] Wed, 03 November 2010 09:34 Go to previous messageGo to next message
Michel Cadot
Messages: 57599
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"How to Manually Cleanup Advanced Queuing Tables", Metalink note 203225.1

Regards
Michel
Re: User management [message #481609 is a reply to message #481433] Thu, 04 November 2010 09:54 Go to previous messageGo to next message
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.
Re: User management [message #481612 is a reply to message #481609] Thu, 04 November 2010 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 57599
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
As of now ,i have found the solution.

What about to share it with us?

Regards
Michel
Re: User management [message #481916 is a reply to message #481612] Mon, 08 November 2010 05:59 Go to previous messageGo to next message
y_nitin
Messages: 3
Registered: November 2010
Location: Gurgaon
Junior Member

I have extracted the tables from DBA_TABLES though they are not listed in dba_queue_tables

Reason for the same is yet to be looked into
Re: User management [message #481952 is a reply to message #481916] Mon, 08 November 2010 09:40 Go to previous message
Michel Cadot
Messages: 57599
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand.
Could you post the statements you executed?

Regards
Michel
Previous Topic: Tablespace encryption - Data Migration (3 Merged)
Next Topic: Password History
Goto Forum:
  


Current Time: Wed Apr 16 04:24:40 CDT 2014

Total time taken to generate the page: 0.09531 seconds