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.