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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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