我們在刪除數據庫用戶時候會碰到如下錯誤
?
?
SQL> DROP USER sys_xj cascade;
DROP USER sys_xj cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
解決方法：
?
1.查詢出還在連接的此用戶會話進程
?
SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='SYS_XJ'
2 ;
SID SERIAL#
---------- ----------
452 8801
474 1523
?
2.結束此用戶所有會話
?
SQL> ALTER SYSTEM KILL SESSION '452,8801';
System altered.
SQL> ALTER SYSTEM KILL SESSION '474,1523';
System altered.
?
3.刪除用戶
SQL> DROP USER sys_xj cascade;
User dropped.
?
此時刪除成功
?
)
