Home » RDBMS Server » Server Administration » error while droping user (windows)
error while droping user [message #549381] Fri, 30 March 2012 01:08 Go to next message
sandeip
Messages: 23
Registered: May 2011
Location: pune
Junior Member
Got following error while droping user
Please help its very urgent

DB:9.2.0.8.0 OS:Windows 2003

SQL> drop user custom cascade;
drop user custom cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-21700: object does not exist or is marked for delete


Please reply,its very urgent
Re: error while droping user [message #549387 is a reply to message #549381] Fri, 30 March 2012 01:38 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Check for any DDL triger
2/ Activate a SQL trace on your session and check the statement that raises the error.

A) Nothing is urgent in a forum
B) If you want a quick reply you should carefully choose your forum. A forum about networking is not really the good one to get an answer about "drop user", don't you think?

Regards
Michel
Previous Topic: Archive log file's sequence number reduced.
Next Topic: V$BH & how to get the block number of the empty block?
Goto Forum:
  


Current Time: Fri Mar 29 06:48:42 CDT 2024