ora-14452 - attempt to create, alter or drop an index on temporary table already in use

14452, 00000, "attempt to create, alter or drop an index on temporary table already in use"
// *Cause:  An attempt was made to create, alter or drop an index on temporary
//          table which is already in use.
// *Action: All the sessions using the session-specific temporary table have
//          to truncate table and all the transactions using transaction 
//          specific temporary table have to end their transactions.

SELECT s.username
FROM   v$lock      l
      ,dba_objects o
      ,v$session   s
WHERE l.id1 = o.object_id
AND   s.sid = l.sid
AND   o.object_name = '<Your Table Name>';

SCOTT@orcl_11g> CREATE GLOBAL TEMPORARY TABLE test_tab AS
  2  SELECT * FROM dept WHERE 1 = 2
  3  /

Table created.

SCOTT@orcl_11g> CREATE USER test IDENTIFIED BY test
  2  /

User created.

SCOTT@orcl_11g> GRANT CONNECT, RESOURCE TO test
  2  /

Grant succeeded.

SCOTT@orcl_11g> GRANT ALL ON test_tab TO test
  2  /

Grant succeeded.

SCOTT@orcl_11g>

TEST@orcl_11g> INSERT INTO scott.test_tab (deptno, dname, loc)
  2  VALUES (1, 'testname', 'testloc')
  3  /

1 row created.

TEST@orcl_11g> 

SCOTT@orcl_11g> DROP TABLE test_tab
  2  /
DROP TABLE test_tab
           *
ERROR at line 1:
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use


SCOTT@orcl_11g> SELECT v.oracle_username
  2  FROM v$locked_object v, all_objects a
  3  WHERE v.object_id = a.object_id
  4  AND a.object_name = 'TEST_TAB'
  5  /

ORACLE_USERNAME
------------------------------
TEST

SCOTT@orcl_11g> SELECT s.username
  2  FROM   v$lock	l
  3  	   ,dba_objects o
  4  	   ,v$session	s
  5  WHERE l.id1 = o.object_id
  6  AND   s.sid = l.sid
  7  AND   o.object_name = 'TEST_TAB'
  8  /

USERNAME
------------------------------
TEST
TEST

SCOTT@orcl_11g>

SCOTT@orcl_11g> DROP USER TEST CASCADE;

User dropped.

SCOTT@orcl_11g> DROP TABLE test_tab;

Table dropped.

SCOTT@orcl_11g>