Bulk Load Log Files
The log files for the bulk load are 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 | For Oracle database:
This file is used by Oracle to log information about the process used to create the external table. The log file name has the following format, Log_<EntityName>_<LoadId>.log. |
| Bad File | For Oracle database:
This file contains records which cannot be loaded because of errors. The Bad file name has the following format, Bad_<EntityName>_<LoadId>.bad |
| Discard File | For Oracle database:
The file contains records that fail the condition in the LOAD WHEN clause of the statement used to create the external table. This file is created only if any records are encountered that fail the LOAD WHEN condition. The Discard file name has the following format, Discard_<EntityName>_<LoadId>.discard. |
| Stored Procedure Logs | For Oracle database: This file is created by the procedures which copy the records from the external table to the actual table. This file displays any errors encountered during the copying process. It also displays the current status of the load. The file name has the following format,
Log_SP_<EntityName>_<LoadId>.log.
For PostgreSQL database: This file is created by the procedures which copy the records from the external table to the actual table. The file displays the errors encountered during the copying process. It also displays the current status of the load. The file has the following format, Log_SP_<EntityName>_<LoadId>.log. |