Hii Halo and sri,
I am sorry !!.I forget to mention one thing..... I don't get any export file from that remote database....

we only have select privileges to some of the table we need....

SO what you thing..... whether i can implement..... create table.... as select.... or that's not good for a 2 million record or more.. ... please let me know the option.....