you can copy tables using below job.
parameterize your source db and target db.
put the below query in tOracleRow component
"create table "+context.tgt_db_name+"."+((String)globalMap.get("tOracleTableList_1_CURRENT_TABLE"))+" as select * from "+context.src_db_name+"."+((String)globalMap.get("tOracleTableList_1_CURRENT_TABLE"))+" where 1=0;"
I can clearly see the image in my previous post. anyway attaching again
I'm not sure that job will work since we are dealing with only one database.
What's about copying structure from Oracle database to MySQL database? Or maybe two different instance Oracle DB
My suggestion :
toracleTable_list --- iterate ---> toracleinput(schema should be dynamic) ------- main ----------> toracleoutput / tmysqloutput (schema should be dynamic)
You will get tables name from toracletable_list
By the way,have you solved this problem?What is the specific settings of tOracleRow ? I have the same problem. I want to copy 50 tables from one database to another database. Can I have your attention,please?
Have you run the job successfully? I have set the same job,but the job does not work,the third one has problems. If you have any time ,please tell me how to set the three parts of the job. Thank you very much.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables