Hi together,

we´ve got the problem, that we´re trying to unload a table and load it on antother server. Does anybody how to get access to the unload file on the other server ?
Thanks a lot

koeningskind

Hi,

You attenmpted run "insert into table name select * from database@servertcp:table name" ?

Gustavo.

Hi Gustavo,

yes, that´s how we used to do it, but since the table has more than 4.7 million rows, we got a locking poblem. That´s why we are trying to find another solution. Any other ideas, how we can unload the table on one server, copy it the the second server and load it from there with maybe dbload or so ? we also got the informatins, that if we create an external tabel we have to put it in a raw device, but then the all servers have to be build exaxtly the same.
Hope I explaind it, so everbody understands i t :-)
Thanks

koeningskind