Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Can SQL*Loader do this?
If SQL*Loader can't load a row of data because of integrity constraint
violation, can I ask SQL*Loader to change one value and continue to load this
row? I.e., if it can't load "1,John,Doe," because 1 is already taken, can it
auto increment 1 to 2 and try loading "2,John,Doe,"? If that fails again,
increment 2 to 3 and try once more.
Yong Huang
yong321_at_yahoo.com