ORA-01940: cannot drop a user that is currently connected
1.查看用户的连接状态
select username,sid,serial# from v$session;
2.找到要删除用户的sid和serial并杀死
alter system kill session’sid,sid,sid,serial’;
3.删除用户
drop user ‘username’ cascade;
...
原创
2020-04-24 17:29:44 ·
124 阅读 ·
0 评论