Re: What an Oracle DBA needs to do for migrating from Oracle to MySQL?

[John Moll]

You can provide your customer with flat text files as a data and a loader script that customer can execute to load the data from flat files.
Create a SQL script "LOAD DATA INFILE .... " for each extracted table or partition to load the data from txt file into MySQL

Oracle does not really have a decent unload utility into flat file. You can use spool if the amount of data is pretty small.
If you need to send them a lot of data (dozens of giga bytes ) then spool will not work since it uses conventional path. You may want to consider some third party high performance tool that uses direct unload like Fastreader www.wisdomforce.com . Fastreader will automatically create all load scripts for you as well so your customer will have only simply execute one script to load everything you sent him into MySQL