Remove temporary table reported ORA-14452 error Solution

Run the stored procedure, which contains a temporary table. After running, I plan to delete the temporary table report ORA-14452: Anattemptwasmadetocreate, alterordropanindexonte

Run the stored procedure, which contains a temporary table. After running, you want to delete the temporary table report ORA-14452: An attempt was made to create, alter or drop an index on te

Run the stored procedure, which contains a temporary table. After running, you want to delete the temporary table report ORA-14452: An attempt was made to create, alter or drop an index on temporary table which is already in use

Solution:

In fact, you can wait until the resources are released. Or delete the sid.

1. query object_id

Select object_id from dba_objects where object_name = UPPER ('tbl _ 1 ');

-------

1199531

2. Check the session according to object_id

Select sid from v $ lock where id1 = 1199531;

--------

186

3. query SERIAL by sid #

Select serial # from v $ session where sid = 186;

----

57893

4,

Alter system kill session '2017 93 ';

,