With a new installation of DSpace 6.2, pretty generic configuration (e.g., no edits to anything around Flyway/Hibernate/etc.), and a fresh database with Oracle XE 11.2, `./dspace database migrate` fails at "6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration" with the following error
Unless I am missing something, this looks like a bug in the Oracle SQL. It looks like the PostgreSQL commands were just copied into another file without the appropriate modifications (apparently Oracle doesn't handle column renaming in the same way as Postgres).
I ran the relevant SQL data definitions in Oracle directly and got the error reported by Flyway.
The faulty file: https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/workflow/oracle/xmlworkflow/V6.0_2015.08.11__DS-2701_Xml_Workflow_Migration.sql.