如何绕过 ORA-01940: cannot drop a user that is currently connected

SQL〉DROP USER USER1 CASCADE

ERROR：ORA-01940: cannot drop a user that is currently connected

由于当前用户正连接到数据库，所以无法删除

解决办法：

1、查询此用户的会话进程，

select sid,serial# from v$session where username='AR14_ORA_AIO$OWNER'

---------- ----------
SID    SERIAL#

81    39217
105    40100
264    1125

2、结束此用户的所有会话

SQL>ALTER SYSTEM KILL SESSION '81,39217';

System altered.

SQL>ALTER SYSTEM KILL SESSION '105,40100';

System altered.

SQL>ALTER SYSTEM KILL SESSION '264,1125';

System altered.

3、删除用户

SQL〉DROP USER AR14_ORA_AIO$OWNER CASCADE；

这样就可以解决此问题。