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)

 

OR

 

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.

 

Thanks,

Munna

Legend

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