Re: drop user not working

Posted by ErmanArslansOracleBlog on Sep 30, 2022; 12:27pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/drop-user-not-working-tp11103p11106.html

Probably a bug..
For instance -> Enhancement request Bug 13385652: DROPPING A USER THAT IS NOT CONNECTED ANY MORE WITHOUT ORA-01940 ERROR

There are some workarounds for this.. (for instance startup restrict and drop, but it may be not be suitable in PROD environments during daily operations.)

The following MOS note may also help ->

Troubleshooting DROP USER HANGS / ORA-01940 Issues. (Doc ID 1291804.1) --- you set the events, you see the cause and then you take actions..