OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » drop user cascade

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

drop user cascade [message #221271]

Mon, 26 February 2007 01:30

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

i want to drop the user nctexmis_test and i used the following
but i got the following error

SQL> drop user nctexmis_test cascade;
drop user nctexmis_test cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04021: timeout occurred while waiting to lock object NCTEXMIS.YRN_DELIVERY_CHALLAN_DETAIL

can anybody tell me what this error means?

Report message to a moderator

Re: drop user cascade [message #221291 is a reply to message #221271]

Mon, 26 February 2007 03:34

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

ORA-00604: error occurred at recursive SQL level string

Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).

Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.

Oracle

ORA-04021: timeout occurred while waiting to lock object stringstringstringstringstring

Cause: While waiting to lock a library object, a timeout is occurred.

Action: Retry the operation later.

Report message to a moderator

Re: drop user cascade [message #221295 is a reply to message #221271]

Mon, 26 February 2007 03:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Version?
There should be a related trace/dump notified in alert_sid.log.
Historically, there are a few known bugs on this. Mostly it has to do the execute privileges on the underlying objects and certain SYS objects.

Report message to a moderator

Previous Topic:	starting I-SQLPLUS from the client
Next Topic:	Import Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:27:03 CDT 2024