Migrating from Oracle CTL to MySQL
I would like to move from Oracle to MySQL and one of the important steps is to replace the actual job built in the Oracle environment.
Basically every day I get "oracle" dump files from another Oracle environment (mainly CTL or Oracle table export). Today my Oracle jobs were loading the retrieved data (CTL ...) into my Oracle tables. Now I would like to replace my Oracle tables in MySQL tables while continuing to receive the file coming from the Oracle environment.
So. Do you have the same tools or artifacts for reading Oracle (or Oracle dump) CTL files from a MySQL environment? I've already used the mysqlimport GUI, but that doesn't suit my needs. I need a script / command.
Nothing comes to mind - you may need to write your own export / import scripts - for example to write CSV files from Oracle and to load MySQL from those CSV files ... or a job that speaks to both ...
Even though Google contains some firewall import / export tools - it might be worth trying ...
source to share