遇到ORA-01940: cannot drop a user that is currently
来源:互联网 发布:网络教育 档案 公考 编辑:程序博客网 时间:2024/06/05 18:26
ORA-01940: cannot drop a user that is currently connected
遇到这个问题,需要先kill掉所有使用该用户连接数据库的进程:
这里有个简单的方法:
(注意:全部大写 )
SQL> SELECT 'ALTER SYSTEM KILL SESSION '||''''||SID||''''||','||''''||SERIAL#||''''||';' as KILLER FROM V$SESSION WHERE USERNAME='JC_CC_XC';
遇到这个问题,需要先kill掉所有使用该用户连接数据库的进程:
这里有个简单的方法:
(注意:全部大写 )
SQL> SELECT 'ALTER SYSTEM KILL SESSION '||''''||SID||''''||','||''''||SERIAL#||''''||';' as KILLER FROM V$SESSION WHERE USERNAME='JC_CC_XC';
0 0
- 遇到ORA-01940: cannot drop a user that is currently
- 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 的解决办法
- Cannot drop database "databasename" because it is currently in use.
- drop user a cascade:ORA-00604 ORA-00942 ORA-06512
- Cannot drop the database 'databasename' because it is currently in use
- 从苏宁电器到卡巴斯基第33篇:番外篇——晒一晒病毒分析师的桌面(下)
- Java.sql.Date精确度问题处理
- X-Frame-Options配置
- Java连接虚拟机的redis报错问题解决办法
- crowd windows
- 遇到ORA-01940: cannot drop a user that is currently
- 公钥和私钥联系和区别
- Java中的容器类List、Set、Map的对比
- 用WINHEX合并两个或多个BIN文件
- CMake构建CUDA项目
- 很不错的网页收集,受用了
- ubuntu系统安装git软件
- python学习笔记 --- 关于openers和handlers
- 木雨音乐 项目开发(七)我的收藏界面