drop user not working

Posted by Roshan on Sep 28, 2022; 7:26am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/drop-user-not-working-tp11103.html

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