While using When clause in sqlldr . It generate too many lines as below -
'Record 1: Discarded - failed all WHEN clauses.'
'Record 2: Discarded - failed all WHEN clauses.'
'Record 3: Discarded - failed all WHEN clauses.'
'Record 4: Discarded - failed all WHEN clauses.'
if it reject millions of records . in log file it shows millions of lines. so size of log file is too big.
It seriously takes my Hard disk space.
at the same time I need other details of log file like --
125466 Rows successfully loaded.
0 Rows not loaded due to data errors.
65523 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Run began on Fri Jan 23 12:27:16 2015
Run ended on Fri Jan 23 12:27:18 2015
Elapsed time was: 00:00:01.70
CPU time was: 00:00:01.16
Any settings in SQLLDR to avoid this lines...?
Oracle 11.2.0.1.0
Windows 2008