RE: "DB Link are Inherently Slow" -- True or False?

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: mark.powell@xxxxxxx
  • Date: Tue, 15 Jul 2008 11:00:49 -0600

Another important consideration is transactional integrity and data accuracy. You get that with database links, but not with export/import, unload/load, etc. Faster is less useful if its less reliable... ;-)


Just chiming in with another US$0.02...



Quoting "Powell, Mark D" <mark.powell@xxxxxxx>:

Slow is a relative term.  If the alternate transfer method is an export,
FTP, and import then even if the insert select across the link was
slower than the import step it is likely to be faster than the combined
exp/imp or exp/FTP/imp process.

The real question is how important is the transfer speed?  How often
will the transfer need to be performed?  Will the receiving object need
to be re-created, cleared out prior to the task or will the data need to
be merged?  If the data is merged what are the chances of getting an
error?

The answers to these questions should allow you to choose the best
solution for your needs.
--
//www.freelists.org/webpage/oracle-l


Other related posts: