1 查出用户的session:
SELECT SID, SERIAL# FROM V$SESSION WHERE USERNAME='ICDPUB';
2 杀掉用户ICDPUB的session:
ALTER SYSTEM KILL SESSION 'SID, SERIAL#';
3 删掉用户ICDPUB
DROP USER ICDPUB CASCADE;
ps:如何查看当前登录数据库的用户:
SELECT * FROM V$SESSION WHERE TYPE='USER';