ORA-01940: cannot drop a user that is currently connected

ORA-01940: cannot drop a user that is currently connected

Solution:

sql> drop user oracle;
drop user oracle
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

sql> select sid, serial# from v$session where username = ‘oracle‘;
SID    SERIAL#
—–  ——–
17         37

sql> alter system kill session ‘17,37;
System altered.

sql> drop user oracle;
User dropped.

  • September 29, 2016 | 40 views