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

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='STRMADMIN';

SID SERIAL#
---------- ----------
1059 280

SQL> alter system kill session '1059,280' ;

System altered.

SQL> drop user strmadmin cascade ;

User dropped.

SQL>

ITPub博客

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