Error on line 0 DROP USER "OPS$SBF" CASCADE ORA-01940: cannot drop a user that is currently connected
I tried this command:
DROP USER "ops$sbf" CASCADE in TOAD
but it's showing the error as I mentioned above. Please help.
Dig Deeper on Oracle error messages
Related Q&A from Mike Ault
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists. Continue Reading
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to... Continue Reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.