删除临时表报ORA-14452错误解决方法

跑存储过程，里面有张临时表。跑完后打算删除临时表报ORA-14452：An attempt was made to create, alter or drop an index on temporary table which is already in use解决方法：实际上要么就是等，等到资源释放。要么就是删除sid。1、查询object_idselect object_id from dba_objects where object_name=UPPER（"TBL_1"）;-------11995312、根据object_id查出sessionselect sid from v$lock where id1=1199531;--------1863、根据sid查询SERIAL#select serial# from v$session where sid=186;----578934、alter system kill session "186,57893";更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址