错误提示
-
SQL> DROP USER TMSTEST cascade ;
-
DROP USER TMSTEST cascade
-
*
-
ERROR at line 1:
- ORA-01940: cannot drop a user that is currently connected
首先查找到连接的seesion，生成一个kill语句
生成语句
-
SQL> select \'alter system kill session \'\'\'||sid||\',\'||serial#||\'\'\' immediate;\' sss from v$session where username=\'TMSTEST\';
-
-
sss
-
-----------------------------------------------------
- alter system kill session \'30,62441\' immediate;
kill seesion
-
SQL> alter system kill session \'30,62441\' immediate;
-
- System altered.
再次删除用户
-
SQL> DROP USER TMSTEST cascade ;
-
- User dropped.