Record is locked by another user --Oracle行锁解锁
来源:互联网 发布:es nested 查询 java 编辑:程序博客网 时间:2024/04/29 20:26
Oracle修改表中记录时出现record is locked by anotheruser的问题
在操作表时没有commit,导致表被锁,只要执行下面两行语句,就可以了将行锁解锁了。
1.
-- 查看被锁表的sid 和 serial#
2.
-- kill 锁 ,例如输入 alter system killsession '140, 25';
执行完以上两步后,就可以编辑数据了。
原文链接:http://blog.sina.com.cn/s/blog_77f88ea601012jyy.html
0 0
- 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行锁解锁)
- 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 解决方法
- Oracle 数据库 Record is locked by another user 问题解决办法
- Oracle 数据库 Record is locked by another user 问题解决办法
- Oracle 数据库 Record is locked by another user 问题解决办法
- BAPI FOR MD61,MD62,MD63
- exec系类函数实例---产生一个僵死进程
- Android Fragment详解(四):管理Fragment
- 进口报关知识点介绍
- Eclipse最常用快捷键
- Record is locked by another user --Oracle行锁解锁
- asdfa
- 数控设备进口采购经验
- 菜鸟的课设源码~做课设的菜鸟伤不起
- Android与服务器端数据交互(http协议整合struts2+android)
- osg::MatrixTransform和osg::Matrix
- 《程序员编程艺术》
- swift笔记——环境搭建及Hello,Swift!
- 迭代器简述(三)