I do this a lot in my work.

Normally we have the customer export the data to flat-files.
From there I re-create the tables and load the data into Oracle
using sql-loader.

Once loaded I then manipulate the data to migrate it into the
new data-model we designed.