Clever Geek Handbook

Import from oracle to mysql using CTL

how can i import data from oracle database to mysql database using CTL file (generate with Toad for oracle)? Thanks in advance Andrea

0


source to share


1 answer


The CTL file seems to imply that you've tried using SQLLoader to load data. SQLLoader, however, is an Oracle specific tool. It only supports loading data into Oracle, it has no functionality for loading data into MySQL. So I doubt that the control file created by Toad will be helpful.



If you have a control file, that means you have a flat data file to load (i.e., a separate comma-delimited or tab-delimited data file for each table in the database). This is true? If so, then every database has utilities for importing flat files. I'm not a MySQL expert, but I believe MySQL has such a utility. Of course, you can also easily write a small download application in whatever language you are familiar with.

+1


source






More articles:


All Articles