ORA-14452: attempt to create, alter or drop an index on temporary table already in use
Step:
1>select object_id from user_objects where object_name=&object_name;
2>select * from v$lock where id1=&object_id;
3>select * from v$session where sid=&sid;
4>alter system kill session 'SID,SERIAL#';