Enhancement request (I think): I am using the "Tools / Text Importer" tool to load data from .csv files. The data given to me in a file from an analyst is imperfect. Tonight I had 19 out of 579 records that were rejected due to errors. What I would like is a "Rejected record" file or window. If I had that, I would choose "Continue" after each error, and then I would send the "Rejected record" records back to the person who created the data file to let the analyst know that all but the bad records were imported successfully. Then presumably, the analyst would fix the bad records and send back a file with corrected records.
To give some more context to this request, I am using Text Importer instead of using SQL*Loader, and remember that SQL*Loader creates a .bad file of rejected records. I just want the same end result--a set of rejected records. (Does this feature already exist? I looked but could not find it.)
thanks,
pat holmes