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?