Results 1 to 3 of 3

Thread: external table

  1. #1
    Join Date
    Mar 2005
    Posts
    4

    Unanswered: external table

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

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

    Gustavo.

  3. #3
    Join Date
    Mar 2005
    Posts
    4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •