Steve, could you please reopen this issue?
It still happen over Hibernate 4.
I've attached here: https://issues.jboss.org/browse/JBPAPP6-1628 - a jUNIT test case reproducing it.
I know that Oracle Dialect is configured to "dropTemporaryTableAfterUse" as false, but it still trying to drop the HT table, throwing the exception.

Note: This just happen when used XA Datasources. In the test case I am using Bitronix to setup a xa datasource, so you are able to see the Exception.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira