ORACLE删除正在链接的用户

查看abc的链接情况

select username,sid,serial# from v$session WHERE username='abc'

查看链接状态
select saddr,sid,serial#,paddr,username,status from v$session where username is not null

 

删除链接
alter system kill session '67,15788';

删除abc用户
drop user abc cascade

 

方法二：

最快的办法是：
conn /as sysdba
delete from user$ where name='dzysc';
commit;
alter system flush shared_pool;