Dropping Global Temporary Tables
The session(s) using the temporary table can be queried as:

select sid from v$lock where type = 'TO' 
and id1 = (select object_id from dba_objects where object_name = '&amp;temp_table_name');


Then you can kill these sessions or have them release the locks gracefully.