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

    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
    Greenville, SC (USA)
    Depending on the number of rows to be moved, you can use a database link and insert into 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


Posting Permissions

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