(1)查看用户的连接状况
select username,sid,serial# from v$session ------------------------------------------ 如下结果: username sid serial# ---------------------------------------- NETBNEW 513 22974
(2)找到要删除用户的sid,和serial,并删除
如:你要删除用户‘NETBNEW‘,可以这样做:
alter system kill session‘513,22974‘
(3)删除用户
drop user username cascade