ORA-01940: cannot drop a user that is currently connected
Oracle删除用户出错问题
SQL> drop user luan;
drop user luan
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
有其他客户端连接此用户,关掉连接或者杀掉进程
知道到session
select username,sid,serial# from v$session where username='LUAN'
杀掉
alter system kill session '979,52428'
后面删除用户还是报错
SQL> DROP USER LUAN;
DROP USER LUAN
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'LUAN'
在后面加一个 cascade 就可以了,会有点慢
SQL> DROP USER LUAN cascade;
User dropped.