This discussion is archived
4 Replies Latest reply: Jul 3, 2013 2:03 AM by ratina RSS

Data Transffer over DB Link

c2b2107a-cab4-4ef0-87a5-2268161bca8f Newbie
Currently Being Moderated

Hi Every One,


Please help  me to providing the best solution for below scenario.


I‘ve to migrate data from one DB to another DB . Both DB’s are different instance. I’ve created the DB links and granted Select privileges on required tables to destination Schema.


There are around 10 tables and each table contains 2 – 3 million rows approximately.


Now my question is for this data transfer should I use:


Using Direct Insert ..Select statement  ( Which contains ONLY SQL and reduces context switching)




Copy the source table data into local collections and insert the data by selecting from collections.( By using limit )


And I cannot use COMMIT , So that the entire process executes successfully or  fails.


I don’t want to some records to be inserted and if the process fails then do the analysis and insert the remaining records. This would be  a problem when we are migrating data in production.


And what are the problems we face while accessing data over a DB link.





  • Correct Answers - 10 points
  • Helpful Answers - 5 points