Home » RDBMS Server » Server Administration » ORA-14452: while drop user cascade
ORA-14452: while drop user cascade [message #252157] Wed, 18 July 2007 00:50 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
while i am trying to drop a user

SQL> drop user ncl_test cascade;
drop user ncl_test cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already in use

what could be the reasons?
Re: ORA-14452: while drop user cascade [message #252173 is a reply to message #252157] Wed, 18 July 2007 01:18 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what could be the reasons?

You have a DLL or ON DROP trigger that does something wrong.
Fix it.

Regards
Michel
Previous Topic: upgrading 9.2.0.6 to 9.2.0.7
Next Topic: insufficient privileges
Goto Forum:
  


Current Time: Mon Dec 05 10:44:27 CST 2016

Total time taken to generate the page: 0.09392 seconds