Home » RDBMS Server » Server Administration » drop user cascade
drop user cascade [message #221271] Mon, 26 February 2007 01:30 Go to next message
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?
Re: drop user cascade [message #221291 is a reply to message #221271] Mon, 26 February 2007 03:34 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
Re: drop user cascade [message #221295 is a reply to message #221271] Mon, 26 February 2007 03:39 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: starting I-SQLPLUS from the client
Next Topic: Import Error
Goto Forum:
  


Current Time: Thu Dec 08 03:59:56 CST 2016

Total time taken to generate the page: 0.14042 seconds