Cause
~~~~~~~

If the global temporary table was created with "on commit preserve rows" option,
the global temp table would still be locked eventhough transaction was commited.


Fix
~~~~

+ Disconnect and connect the session


the metalink says..

https://metalink.oracle.com/metalink...,1,1,helvetica