跳转到主内容
趣航编程网 - 趣学编程,启航技术之路!

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

跑存储过程,里面有张临时表。跑完后打算删除临时表报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';

本文永久更新链接地址:

,

相关文章