Its not a better practice ( i think i can say this ) to have DB link and transfer data by comparing data on remote DB..This will only slow up process.

Rather use COPY cmd to load into Temp_Table & now u can play with this data.

BTW, Hrishy Long time since you posted?

Abhay.