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

来源:互联网 发布:模拟画像软件 编辑:程序博客网 时间:2024/05/16 12:52

Problem:

SQL> drop user ecrpuser cascade;
drop user ecrpuser cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

Solution:

select sid||','||serial# from v$session where username = 'ECRPUSER';

alter system kill session 'sid,serial#';


原创粉丝点击