I wrote a program named (ora2mysql) when learning MySQL C API client programing, it can be used for data migration from Oracle to MySQL database, and I think it's definatelly a good utility for DBAs who need manages both Oracle and MySQL databases.
It's very easy to use it, for example:
D:\>ora2mysql user1=scott/tiger user2=test/test@localhost:3306:test table=emp
0 rows processed at 2011-04-02 15:03:08.
2 rows processed at 2011-04-02 15:03:08.
The performance is quite good, with a 35 fields table, the average speed is 6000+ rows per second.
$ ./ora2mysql.bin parfile=test.txt
0 rows processed at 2011-04-08 14:04:24.
100000 rows processed at 2011-04-08 14:04:39.
200000 rows processed at 2011-04-08 14:04:54.
300000 rows processed at 2011-04-08 14:05:09.
400000 rows processed at 2011-04-08 14:05:24.
500000 rows processed at 2011-04-08 14:05:39.
600000 rows processed at 2011-04-08 14:05:54.
700000 rows processed at 2011-04-08 14:06:09.
800000 rows processed at 2011-04-08 14:06:24.
900000 rows processed at 2011-04-08 14:06:39.
1000000 rows processed at 2011-04-08 14:06:54.
1000000 rows processed at 2011-04-08 14:06:54.
I have upload the Windows/Linux 32/Linux x86-64 binary to my site for download, for linux binary the big file is statically linked with MySQL client library.
If you have any problem for this utility info me by email, if you feel it really helps you, you can make donation with PayPal. This utility is always free for you.