I have this requirement that I have been trying to solve for a couple of days now.
I have this source DB. The objective is to extract data from this source DB and insert into a oracle table. The meta data for both tables are the same (1-1 mapping).
Essentially I am trying to do a "insert into <tablename_1> select * from <tablename_2>" through a JDBC connection.