oracle的用户session

删除一个用户，报错，删除的用户正在连接中。

SQL> drop  user user_test cascade;drop user user_test cascade*ERROR at line 1:ORA-01940: cannot drop a user that iscurrently connected

 

查看一下该用户的session状态

SQL> select username,sid,serial#,status from v$session where username='USER_TEST';USERNAME   SID  SERIAL#  STATUS---------- ---- ------- --------USER_TEST  136  15565    INACTIVE

Kill该用户(用SID SERIAL#)

SQL> alter system kill session '136,15565';System altered.

 

再次删除，成功

SQL> drop  user user_test cascade;User dropped.