ORA-01940: cannot drop a user that is currently connected
来源:互联网 发布:模拟画像软件 编辑:程序博客网 时间:2024/05/16 12:52
Problem:
SQL> drop user ecrpuser cascade;drop user ecrpuser cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
Solution:
select sid||','||serial# from v$session where username = 'ECRPUSER';
alter system kill session 'sid,serial#';
- ORA-01940: cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected
- ORA-01940:cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected
- ORA-01940:cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected
- ora-019401 cannot drop a user that is currently connected
- ERROR:ORA-01940: cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected 问题解析
- Linux中删除Oracle用户 提示 ORA-01940: cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected 的解决办法
- 遇到ORA-01940: cannot drop a user that is currently
- Cannot drop database "databasename" because it is currently in use.
- drop user a cascade:ORA-00604 ORA-00942 ORA-06512
- This device is not currently connected
- ASCII与中文互转
- Hibernate调用执行存储过程
- Andorid Map布局 可添加自定义控件
- 修改tableview各个 section之间的间隔
- ubuntu 安装jdk,gogent
- ORA-01940: cannot drop a user that is currently connected
- 内存中的数据对齐
- 在前台加入分页的html代码
- IOS下写文件的方法
- 正则表达式学习
- log4j配置
- PowerDesigner 反向工程 Oracle 连接篇
- Oracle PL/SQL判断两个字段相等或不等问题
- 他们为什么成功?中国最赚钱的8家移动游戏公司