Oracle 数据库 Record is locked by another user 问题解决办法
来源:互联网 发布:java获得项目绝对路径 编辑:程序博客网 时间:2024/05/20 04:14
在操作ORACLE数据库的时候,由于执行完,没有COMMIT,多次修改,后来导致那张表被锁住,当编辑时就会出现这个信息,record is locked by another user!
当出现这种情况的时候,只要操作下面几个步骤就可以解锁了。
1.查锁
select t2.username, t2.sid, t2.serial#, t2.logon_time from v$locked_object t1, v$session t2 where t1.session_id = t2.sid order by t2.logon_time;
2.解锁(KILL)
执行命令alter system kill session ‘sid,serial#’
alter system kill session ‘2001,25423’;
阅读全文
1 0
- 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
- ORACLE record is locked by another user?解锁
- Record is locked by another user --Oracle行锁解锁
- ORACLE解锁record is locked by another user
- Record is locked by another user --Oracle行锁解锁
- 制作 shell 脚本压缩 Android 8.0代码
- java模式—装饰者模式
- LeetCode基础-排序-合并排序
- Velocity 在Spring中的配置
- Java技术——你真的了解String类的intern()方法吗
- Oracle 数据库 Record is locked by another user 问题解决办法
- Spring mvc HandlerMapping 实现机制
- CSS进阶
- BZOJ2460 线性基裸题
- SVG中stroke-dasharray及stroke-dashoffset属性
- Python小练习
- 心塞的电路实践
- -要成为精力的管理者,而不是时间的管理者
- Codeforces Round #443 (Div. 2)