Hello,

I am using sql loader to import some data into our oracle 10g database
from a sybase database.
The data is pulled from the sybase database by our own tool and
everything is put in files (two per table: .ctl and .txt file). Our
tool also creates a batch file which contains the sqlldr statements to
import each of the previously created files.
I have one problem though. When the CTL file is not correct (e.g. a
columnname of a table is not the same as the columnname found on the
oracle table), no bad file is created.The error is logged in the log
file, but because we have hundreds of tables, there is no rapid way to
see that import of table xx failed due to column misspelling.

Is there a way to set up sql loader to only make a log file when an
error occured? Or to write the error in another kind of file (maybe
also a .bad file)?

I already tried to write the output of my bad file to its own log
with:
CALL IMPORT_ALL_TABLES.BAT > IMPORT.log
but the messages that matter (the errors) still display on screen and
are not written in the log file.

Greetings

Michèle