AnsweredAssumed Answered

How to send huge data from oracle query results to another database?

Question asked by aravula on Jul 7, 2016
Latest reply on Jan 10, 2017 by shashankg226819

Source is Oracle database and it is fetching about 500,000 records from a table. I'm writing this result into another database. The process is taking about 5 minutes after using batch processing (batches of 50, I tried using more than 50 but it is not making much of a difference).

 

Is there an efficient way to do this? Can the process run faster, like in a minute or so?

 

Thank you

Outcomes