ORA-14450: attempt to access a transactional temp table already in use

find blocked session, and then ask dba to kill the blocked session. 

when the database is a rac, need to consider gv$enqueue_lock

select 'alter system kill session '''||SID||','||SERIAL#||''';' from gV$session where SID in ( select sid from gv$enqueue_lock t where t.type='TO' and id1 =( select object_id from dba_objects 
where object_name = 'GTT_TABLE_NAME' and OWNER='TEST_USER') );