当我们要修改或删除临时表时,如果有其他的session使用该临时表,就会报这个错,如果想暴力破解,解决方法如下:
- 根据临时表TMP_ImpGoodsDtl,查询object_id
select object_id from dba_objects where object_name=upper('TMP_ImpGoodsDtl');
- 根据object_id查询sid
select * from v$lock where id1=object_id;
- 根据sid查询serial#
select * from v$session where sid=279;
- 删除进程
alter system kill session '279,52929';