Bulk Load Log Files

The log files for the bulk load will be created in the same directory where the bulk load files are placed.

There are four types of log files created for each data input file. The first three files are created by Oracle while creating the external table and are known as the log, bad, and discard files. The last file is created by the procedure which moves the records from the external table to the Oracle table.

Log File This file will be used by Oracle to log information about the process used to create the external table. The log file name will follow the format Log_<EntityName>_<LoadId>.log.
Bad File This file contains records which cannot be loaded because of errors. The Bad file name will be of the format Bad_<EntityName>_<LoadId>.bad
Discard File The file contains records that fail the condition in the LOAD WHEN clause of the statement used to create the external table. This file will only be created if any records are encountered that fail the LOAD WHEN condition. The Discard file name will be of the format Discard_<EntityName>_<LoadId>.discard.
Stored Procedure Logs This file will be created by the procedures which will copy the records from the external able to the actual table. This file will display any errors encountered during the copying process. It will also display the current status of the load. The file name will follow the format Log_SP_<EntityName>_<LoadId>.log.