ORA-01940: 无法删除当前连接的用户

SQL> drop user hzld_wb_query cascade;

drop user hzld_wb_query cascade

ORA-01940: 无法删除当前连接的用户

查询session 中还在活动用户

SQL> select username,sid,serial#,status from v$session where username is not null;

USERNAME                              SID    SERIAL# STATUS

------------------------------ ---------- ---------- --------

HZLD_WB_QUERY                          17        158 INACTIVE

WUHEN                                  40        393 INACTIVE

WUHEN                                  46        856 ACTIVE

WUHEN                                  48       1098 INACTIVE

杀死进程

SQL> alter system kill session '17,158';

System altered

可以删除用户了

SQL> drop user hzld_wb_query cascade;

User dropped