Loading csv and writing bad records with individual errors

I am loading a csv file into my database using SQL Loader. My requirement is to create an error file combining the error records from .bad file and their individual errors from the log file. Meaning if a record has failed because the date is invalid, against that record in a separate column of error description , Invalid date should be written. Is there any way that SQL loader provides to combine the too. I am a newbie to SQL loader. Database being used Oracle 19.c



Read more here: https://stackoverflow.com/questions/66279226/loading-csv-and-writing-bad-records-with-individual-errors

Content Attribution

This content was originally published by Shubha Parashar at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: