drop user stat_fine cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
锁定用户:
alter user STAT_FINE account lock;
通过v$session视图查找连接这个用户的session
select sid,serial#,username,status,MACHINE from v$session where username='STAT_FINE';
kill掉使用该用户连接的session:
alter system kill session '&sid,&serial#';