ORA-14450:试图访问已经在使用的事务处理临时表
解决步骤
1、查找表对象对应的OBJECT_ID
SELECT * FROM DBA_OBJECTS WHERE OBJECT_NAME='TMP_SHIPMENT_LIST';
2、拼接杀进程语句
select 'alter system kill session '''||SID||','||SERIAL#||''';' from V$session where SID in ( select sid from v$enqueue_lock t WHERE id1='89891' ) ---89891是OBJECT_ID
3、执行杀进程命令
alter system kill session '13,29524';
alter system kill session '353,63285';
alter system kill session '461,2807';