I am trying to reinitialize an Oracle DB and see the following error:
[sql] Failed to execute: drop user conns cascade
[sql] java.sql.SQLException: ORA-01940: cannot drop a user that is currently connected
[sql] Failed to execute: create user conns identified by conns default tablespace tbs_conns temporary tablespace temp1
[sql] java.sql.SQLException: ORA-01920: user name 'CONNS' conflicts with another user or role name
The problem is that NO ONE is connected : this is an instance on my local computer, external connections and I just rebooted and did not start anything. The only thing I can think of is that Oracle may have some kind of background (cleanup?) Task that causes this problem, but I don't know how to find / manage it. Any ideas?
Update : This script actually deletes and re-initializes the heap table, and then attempts to restart it a few times, I got the same error message, but in a different table Failed to execute: drop user csmy cascade. After several attempts, he moved on to another user: Failed to execute: drop user deb cascade. Something seems to be blocking these tables, one at a time, in alphabetical order!
Update 2 : after restarting the script about 15 times - every time you don't keep up with the table a little further alphabetically - it went all the way and everything works. Anyway, I would like to know exactly what happened - I think this is some kind of Oracle background process, but I don’t know how to check it.
Update 3 . I ran into this problem again the last time I ran the script again, this time without executing the "cap" user. To try something new, I ran sqlplus and manually ran the command drop user cap cascade, and that’s all, it worked perfectly. I tried the script and it ended. Therefore, since manually disabling the user’s work without problems, I strongly suspect that the script widget itself.
source
share