oracle 更新不了行数据解决方法

2021-11-28 01:59:23

登陆oracle服务器
su - oracle
sqlplus / as sysdba
select l.session_id,o.owner,o.object_name from v$locked_object l,dba_objects o where l.object_id=o.object_id and o.owner = '数据库名' and o.OBJECT_NAME = '表名';
SELECT sid, serial#, username, osuser FROM v$session where sid in(5187,6156);
ALTER SYSTEM KILL SESSION '5187,63609';
ALTER SYSTEM KILL SESSION '6156,46506';
`

码农公寓