SQL*Loader : bad file vs discard file
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