I read the error message saying the combined length of the columns comprising the index is to big ie the sum of the columns size exceeds 1024 characters which MySQL / INNODb can't handle
The resolution is to look at the table defintion and work out if you really need to have columns that size
Firt off I'd check the size and types of the columns in the Oracle and ensure you have got the closest match in MySQL, where there are discrepancies size up.
I'm surprised you need so many varchar columns, especially those defined as ID or OID - suspect these should in reality be type Integer
The other odd thing is there is no primary key defined - unusual in an SQL table definition, but not unkown