Hi,
I have around 100 million rows to be loaded in a table as a refresh and this happens every week. If the job aborts in the middle say after loading around 70 mil rows..is there any way to re-start it and load only the remaining 30 mil rows?
oracle load restart
Moderators: chulett, rschirm, roy
This has been covered here before, many times as I recall. In summary, if you are loading sequentially, then you can restart at the record from point of failure. If not though, you have the complexity added of not knowing where you got to exactly, so that leaves the options of:
- Deleting the data out and starting over from row #1
- Starting over and overwriting (perhaps via an upsert)
- Starting over via referential checking between source and table (before attempting insert)
- Deleting the data out and starting over from row #1
- Starting over and overwriting (perhaps via an upsert)
- Starting over via referential checking between source and table (before attempting insert)
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
you can use the Oracle load option parameter in your job but make sure your data is clean. If you have already staged the data in a dataset ot sequential file then use bulk loading option, because i have many times faced issues with index (being unusable -due to duplicate data). So before going for a Bulk load option make sure your data is clean and you have staged it so if something happens you can you the staging file as source.
Thanks
Karthick
Karthick