Hi
I got a requirement to get data from one database and populate to another database. Could any one please suggest the efficient way to do it.
Below are the constraints I have.
1. Table structures are not similar, One or more tables has to be joined in source DB to get data for one table in target DB. Some thing like Target DB has views built using source tables.
2. I have suggested to use DB Link, but this idea didn't get approved saying DB link affects DB performance.
Some one pls suggest the approach for it. Thanks.