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

From: Tim Gorman <>
Date: Tue, 15 Jul 2008 11:00:49 -0600
Message-ID: <>

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" <>:

> 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.

Received on Tue Jul 15 2008 - 12:00:49 CDT

Original text of this message