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
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.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
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
buy it
for 30% off directly from the publisher.
|
