Erman Arslan's Oracle Forum › Database

drop user not working

Classic

List

Threaded

2 messages Options

Roshan

drop user not working

Oracle DB 19c

Hi Erman,

can you please advise why drop is not working even user is not in v$session?

SQL> drop user CIBLENDINGPPD cascade;
drop user CIBLENDINGPPD cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

Is it a bug on DB?

Regards

ErmanArslansOracleBlog

Re: drop user not working

Administrator

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..