Question: What is the difference
between the bad file and the discard file in SQL*Loader.
Answer: The bad file and discard
files both contain rejected rows, but they are rejected for
- Bad file: The bad file
contains rows that were rejected because of errors.
These errors might include bad datatypes or referential
- Discard file: The discard
file contains rows that were discarded because they were
filtered out because of a statement in the SQL*Loader
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.