Re: Faster transfer of 2 billion records between two database tables
Posted by:
Mona S
Date: April 20, 2018 01:24PM
Using JDBC, the data was being processed and transferred at around 700 rows/minute which would take years. Insert...Select query transferred 20 million rows in 24 hours. I couldn't run delete query since I creation of duplicate table is still going on. I ma looking for a software that would complete the complete query in few hours. Can you please elaborate more on what you mean by dupe-skip logic? Also, do you think converting original table to csv format, process text on csv file, and convert csv file to a new table be a good idea?
Subject
Written By
Posted
Re: Faster transfer of 2 billion records between two database tables
April 20, 2018 01:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.