Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Red face Unanswered: Need Suggestions...sqlloader

    Hi all

    I have the following scenario:

    Every night I get an text export from Informix that I need to upload into two (later three) Oracle boxes. It is around 900 000 records. The old data needs to stay intact for as long as possible, so I need to upload new data while keeping the old till the last second. Is this possible?

    It may be a stupid question...but I dont know the answer.

    Also, since this is a work in progress, what would be a better way to handle this kind of scenario in future other than ftping files all over the place and running sqlloader?

    Thanks for any suggestions!

    Craig

  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    15
    It may help you,

    using append option in SQL loader you can insert new data to db.

Posting Permissions

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