All Forums Tools
r123 5 posts Joined 05/09
07 May 2009
How to skip data errors during fastload?

Hi,Is it possible to skip data errors during fastload and continue with loading other records from file?I have information in tab delimitted text files and in case some field is too long fastload stops to load all the data and reports the error.In Oracle sqlloader records would go to bad file and I would be able later to decide wether I would like to deal with it or leave it as it is. Is something similar with fastload possible?regards,Roberts

Jimm 298 posts Joined 09/07
07 May 2009

Use the NOSTOP option on the SET RECORD command.

r123 5 posts Joined 05/09
07 May 2009

Thank you! nostop helped.Regards,Roberts

feinholz 1234 posts Joined 05/08
12 May 2009

BTW, the NOSTOP option only works for VARTEXT record formats. It does NOT work for the binary formats.

--SteveF

You must sign in to leave a comment.