Approved Dirk's changes (thanks a lot) and put them into the upgrade scripts as well. I did not test the upgrade, maybe someone with a running Oracle installation can do.
Fixed the create table statements, so that the tables are being created under Oracle. Not sure about the semantics, needs to be double-checked by Malte (see #1393)