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("
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