Oracle SQL*Loader – Working with Discarded and Rejected Records

In this tutorial you will learn how to use the options in SQL*Loader for generating Bad File, SQL*Loader Rejects, Oracle Database Rejects, Discard File, Log File and Logging Information. Consider a scenario where you have a data file with city, states and zip codes. You are interested in loading data only for one particular state and reject any record which does not have a zip code. Such records which you are not interested can be in the discard file. SQL*Loader rejects records with missing quotes and Oracle database rejects records… Read More