跑存储过程，里面有张临时表。跑完后打算删除临时表报ora-14452：an attempt was made to create, alter or drop an index on te
跑存储过程，里面有张临时表。跑完后打算删除临时表报ora-14452：an attempt was made to create, alter or drop an index on temporary table which is already in use
解决方法：
实际上要么就是等，等到资源释放。要么就是删除sid。
1、查询object_id
select object_id from dba_objects where object_name=upper('tbl_1');
-------
1199531
2、根据object_id查出session
select sid from v$lock where id1=1199531;
--------
186
3、根据sid查询serial#
select serial# from v$session where sid=186;
----
57893
4、
alter system kill session '186,57893';
本文永久更新链接地址：
，