HHH-3422 is still a problem. It causes a ORA-01754 error on oracle. Fix is easy. change the oracle dialect to use clob which can be used more than once in a table on oracle:

registerColumnType( Types.VARBINARY , "blob" );
registerColumnType( Types.LONGVARCHAR, "clob" );