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;
这样就可以解决此问题。