Q

Unable to drop a user

I'm not able to drop a user. I get the errors "ORA-00604: error occurred at recursive SQL level 2," "ORA-20001: You did not want this object to be dropped, contact DBA check_beforedrop," and "ORA-06512."

I'm not able to drop a user:
SQL> drop user intg cascade;
drop user intg cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-20001: You did not want this
object to be dropped, contact DBA check_beforedrop
ORA-06512: at line 7

SQL> SELECT sid,serial# FROM v$session WHERE username='intg';

no rows selected
Your DBA has coded a trigger to stop you from dropping this user. The ORA-20001 error is a custom error that your DBA created. You will have to contact your DBA to get this user dropped.

Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close