-找到锁住表的sid和serial#
select sid,serial#
from v$session
where sid in (select sid
              from v$lock
             where id1 in (select object_id
                           from user_objects
                          where object_name='BG_UPLOAD_AP_INVOICE_TEMP'));

--删除这个session
alter system kill session 'sid,serial#';
commit;

ITPub博客

ORA-14452錯誤及解決方法（临时表被锁）

最新文章