In Oracle, bad file and discard files both contain rejected rows, but they are rejected for different reasons:
Bad file: The bad file contains records which are rejected because of errors. These errors might include bad datatypee, type conversions or any referential integrity constraints.
Discard file: The discard file contains rows that were discarded because they are filtered out due to filtering criteria's which yu have written in SQL*Loader control file.
Bad file: The bad file contains records which are rejected because of errors. These errors might include bad datatypee, type conversions or any referential integrity constraints.
Discard file: The discard file contains rows that were discarded because they are filtered out due to filtering criteria's which yu have written in SQL*Loader control file.
