I did same migration in my previous company. I dumped sql tables into ascii files and uploaded same using SQL Loader into Oracle. Recreated all the indexes in Oracle. I think this is the best way of doing it, since you will have full control over the data and objects.