删除用户的时候,出现ora-01940错误
SQL> drop user xx;
drop user xx
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select sid,serial# from v$session
2 where username='XX';
SID SERIAL#
---------- ----------
136 33
SQL> alter system kill session '136,33';