Oracle-to-MySQL is a software tool used to move Oracle databases to MySQL server. It works with all Oracle data types except BFILE and MLSLABEL.
It also works with all versions of Unix and Windows MySQL servers. Oracle-to-MySQL lso converts indexes with all necessary attributes. It may also convert individual tables and exports Oracle databases into MySQL dump file.
MySQL dump file is a converter that allows users to have indirect conversion to allow them to have more control during the process. This works by converting your Oracle data first to a local MySQL dump file instead of migrating it to MySQL server directly.
Dump file has MySQL statements that create tables and fills them with the data. Oracle-to-MySQL has limitations. It does not convert views, stored procedures, columns with user-defined types and cannot connect to Oracle databases such as SYSDBA or SYSOPER.