Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    58

    Unanswered: table download upload

    I have to move all the rows of table a into table b(append). They both reside on two different servers. I need to perform some edits on the data in table a. More precisely, an entire column needs to be changed. Table A rows need to be deleted after the completion. Could you please tell me a fast and efficient method? Thank you.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Depending on the number of rows to be moved, you can use a database link and insert into tableb@xxx.world from tablea (again, depends on the manipulation to the column you have to do for table a...

    Another way would be to write out the contents of table a to a dilimited text file and run sqlloader. You can manipulate the data thru your control file as the data loads into table b ...

    Either method, I would try and use a large rollback segment

    HTH
    Gregg

Posting Permissions

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