Re: Data extraction over dblink

That is correct. Attempting cross-load data over dbLink did not scale well. Of course, to be fair, the network itself was somewhat fragile and not something we had control over. Perhaps, with modern equipment and the support of the management, dblink could be a viable solution.

We found that it was more direct, less subject to failure, to create datafiles (usually on CDs or DVDs) and use sql*loader to put the data exactly where we wanted it.

If I recall correctly, asktom.oracle.com has a whole thread devoted to this type of activity.

r,

Gus

Sandeep Dubey wrote:

>Gus,
>
>Can you be more elaborate please? Do you mean dblink didn't scale well?
>
>I am yet to try to write a blob 14 -20 KB each to a flat file and use
>sqlLoader to load in. Has anyone done this without issues?
>
>
>Thanks
>
>Sandeep
>
>
>
>
>>To me it seems that you have a job for SQL*LOADER. Must you extract through
>>the 'net. I never had any real satisfaction try8ing to do that.
>>
>>
>
>
>
>

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