文章分类 -  Oracle

PL/SQL为什么出现Record is locked by another user
摘要：可能是因为在修改数据后没有提交事务 这就是提交按钮，快捷键是F10； 阅读全文
posted @ 2020-12-03 10:48 取昵称好麻烦 阅读(216) 评论(0) 推荐(0)
Oracle 解锁Record is locked by another user
摘要：修改Oracle字段时提示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 wher 阅读全文
posted @ 2020-12-02 11:22 取昵称好麻烦 阅读(100) 评论(0) 推荐(0)