SQL*Loader : bad file vs discard file

Published on by LakshmiSaahul,Dhana Royal

SQL*Loader : bad file vs discard file
What is the difference between the bad file and the discard file in SQL*Loader.
The bad file and discard files both contain rejected rows, but they are rejected for different reasons:
Bad file: The bad file contains rows that were rejected because of errors. These errors might include bad datatypes or referential integrity constraints.
Discard file: The discard file contains rows that were discarded because they were filtered out because of a statement in the SQL*Loader control file.

Advertising
To be informed of the latest articles, subscribe:
Comment on this post