Q
Problem solve Get help with specific problems with your technologies, process and projects.

Unable to drop test user

I created a test user to verify that connection to the database is made. But now I am not able to drop the user.

I created a test user to verify that connection to the database is made. But now I am not able to drop the user. When I give the "drop user test cascade" command it gives me the following error:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7
A good thing to do when you have errors like this is to perform a search on SearchOracle.com's Web site. If you would have searched on ORA-00604, you would have seen that I have previously answered this question.

Dig Deeper on Oracle and SQL

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