OraFAQ Forum: Server Administration » ORA-14452: while drop user cascade

Home » RDBMS Server » Server Administration » ORA-14452: while drop user cascade

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

ORA-14452: while drop user cascade [message #252157]

Wed, 18 July 2007 00:50

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?

Report message to a moderator