record is locked by another user
来源:互联网 发布:手机海报拼图软件 编辑:程序博客网 时间:2024/06/07 20:55
我在删除【某表】里某条数据时提示“record is locked by another user”
首先查看被锁住的表SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_IDFROM ALL_OBJECTS A, V$LOCKED_OBJECT VWHERE A.OBJECT_ID = V.OBJECT_IDAND A.OBJECT_NAME LIKE 'CUX%';CUX%只是个例子...修改成你知道的条件...比如你知道的表名:emp_dept这样你知道session_id了...你就好解决了..kill掉这个sessionalter system kill session 'sid,serial#' 后面的参数是可以从v$session这个视图中取出来的..这样就能解决了
- record is locked by another user
- record is locked by another user
- Record is locked by another user
- record is locked by another user
- oracle record is locked by another user
- oralce record is locked by another user
- 解决record is locked by another user
- Oracle 解锁Record is locked by another user?
- ORACLE解锁 record is locked by another user
- Oracle 数据库 Record is locked by another user 问题解决办法
- ORACLE解锁record is locked by another user
- Oracle操作报错:record is locked by another user
- Oracle Record is locked by another user 解决方法
- Oracle 数据库 Record is locked by another user 问题解决办法
- Oracle 数据库 Record is locked by another user 问题解决办法
- Oracle 数据库 Record is locked by another user 问题解决办法
- Oracle 解锁:Record is locked by another user
- ORACLE record is locked by another user?解锁
- 进程的虚拟空间
- 2013.4.9阶段学习总结
- GSON学习(一)
- Linux Socket编程(不限Linux)
- web service获取本地天气值
- record is locked by another user
- Linux环境下openssl交叉编译、安装和裁剪
- 转:搭建Android UI Testing自动化测试开发环境
- Android 异步加载图片(AsyncImageLoader)
- MongoDB 数据库操作(十)-命令行操作
- 定时关机c++源码
- Java基础面试题
- 一个老国企的信息主管(唐宏梅)
- HTML 标签记录