ORA-01940 如何drop user
使用drop user bpmuser cascade时遇到以下问题
18:03:13 [DROP - 0 row(s), 0.000 secs] [Error Code: 1940, SQL State: 42000] ORA-01940: cannot drop a user that is currently connected
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
查看session中是否存在BPMUSER, 注意这里区分大小写, 小写查不出来!!!
select * from v$session where username='BPMUSER'
select sid,serial# from v$session where username='BPMUSER'
方法一. 如果在远程客户端, 可以用alter system kill session [sid],[serial#];
比如,
SQL> select p.addr from v$process p where pid <> 1 2 minus 3 select s.paddr from v$session s;ADDR--------542B70E8542B7498
