from Oracle dump file into MySQL Database

One Star

from Oracle dump file into MySQL Database

Hi,
I have a new project.
The DBAs from remote Oracle Database will give me the dump files for each table.
I'll have to load them into local MySQL Database.
Is there any direct way to load from Oracle DUMP file into MySQL?
Because, current strategy is that, we will get the .dmp files from remote oracle db,
load it inot local oracle db and then migrate it into local mysql db.
This seems a little complex and a lot of steps.
So, I'm thinking it would be better if I can load the .dmp file from remote oracle db directly into local mysql db.
Please advise....
Thank You.
Community Manager

Re: from Oracle dump file into MySQL Database

Hi
No, it is impossible to load the .dmp file from remote oracle db into local Mysql DB using Talend, you have to load the data into local oracle and then migrate it to mysql.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: from Oracle dump file into MySQL Database

soga