DROP TABLE TMP_TAB_T_AGENT

           *

ERROR at line 1:

ORA-14452: attempt to create, alter or drop an index on temporary table already in USE

SET lines 200 pages 100

col program FOR a20

col MODULE FOR a20

col event FOR a30

SELECT C.SID, C.SERIAL#, C.EVENT, C.PROGRAM, C.MODULE

  FROM V$LOCK A

  JOIN DBA_OBJECTS B

    ON A.ID1 = B.OBJECT_ID

  JOIN V$SESSION C

    ON A.SID = C.SID

 WHERE B.OBJECT_NAME = 'TMP_TAB_T_AGENT';

       SID    SERIAL# EVENT                          PROGRAM              MODULE

---------- ---------- ------------------------------ -------------------- --------------------

      1991      15006 SQL*Net message from client    plsqldev.exe         PL/SQL Developer

ALTER SYSTEM KILL SESSION '1991,15006';