Load Outcome – Log, Bad and Rejected Files

SQL Loader output files are available for download after each run . Refer to Input and Output File Location for details. To ensure file name uniqueness, the output file names are concatenated with the current timestamp.

  • Log file contains the information about the run, including number of record processed, errors encountered and other useful information. The level of logging is controlled by the batch parameter log .

  • Bad and Rejected files contain the records that were rejected by either the SQL Loader or the database. If the errors are not extensive and could be fixed manually, these files can be edited, renamed and used as an input again.