RE: Data extraction over dblink

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 13 Apr 2006 19:05:11 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKAEJPHOAA.mwf@rsiz.com>

If you must go over the net, I've had better throughput with sqlplus copy, probably because it automatically uses array fetches and array writes and has a facility for an interim commit frequency. If the column types you need to move are supported (and make sure you set long long enough if you have longs in the mix), AND if you must use the network instead of some variety of sneakernet or trucknet, sqlplus copy could do the trick. As for scaling, if you toss on a where clause AND you have multiple network pathways (or the one path is big enough not to be the limiting factor) you can attach the source data in multiple segments in parallel.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sandeep Dubey
Sent: Thursday, April 13, 2006 10:09 AM
To: Fenstermacher, Robert
Cc: oracle-l_at_freelists.org
Subject: Re: Data extraction over dblink

Thanks Rob!

Using the export/import, I will need staging tables as data from multiple tables are loaded in one table.

I was wondering if anyone has experience extracting data though db link on internet. What type of performance or issues we get?

Regards

Sandeep
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 13 2006 - 18:05:11 CDT