Re: Restarting Fastload if we have error with the source data file

No, if everything is done correctly, you are actually NOT supposed to drop the error tables in order to restart a job that was paused. Dropping the error tables (and the row in the restart log table) will mean the job will start from the beginning.

Apparently, something was wrong with the error tables and the job could not be resumed. And thus you were instructed to drop them and start all over.