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

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博客 ” ，链接：http://blog.itpub.net/35489/viewspace-630524/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-630524/