SQL*Loader

[arshiah]

While loading data from a flat file, we need to keep a pointer in the file, in case our process of loading the data fails, we need to re-start it from where it stops, and not start from the beginning. Is there a way we can do this?

[DBAtrix]

You could use SKIP. Then determine from your log file how many records were read and how many were skipped, and next time skip the sum of the two.

d.