执行命令:drop user username cascade ,报错ORA-01940: cannot drop a user that is currently connected,可执行以下步骤
1:select * from v$vession where USERNAME = '用户名'
得到用户session的sid ,serial#
2:执行命令 SQL> ALTER SYSTEM KILL SESSION 'SID,SERIAL#'
3:执行命令 drop user username cascade
注:仍执行失败,可根据sid得到spid ,然后执行操作系统命令kill -9
select SPID FROM V$PROCESS P , V$SESSION q
where p.ADDR = q.PADDR and q.SID = '具体值'
得到spid 执行以下步骤
1: 执行操作系统命令 kill -9 spid
2: 执行删除用户命令 drop user username cascade