Transferring huge amount of data

[abhaysk]

100M rows is not such an impresive amount of data, large but not huge.

well, rather than going by just numbers.. one should look at the size of the table (determined by avg row length * number of rows).. after all one is transfering data and size of movement is all it matters..

lets say avg row length is too low (<100), then db link would be the answer irrespective of LAN settings (assuiming atleast 1MBPS which any LAN would have more than this)..

if avg row length is too high i would conisder transportable tablespace or expdp.

rgds
abhay