ignore sqlldr warnings

I use OEM to schedule a database load. This works OK except that the data source is "dirty".

Let me rephrase that last sentence. The data file to load is created from several independant sources that may possibly get the same data. The schema is set to prevent identical data records (primary key) so some records are not loaded. This is fine and sqlldr generates the appropriate warnings.

I have set the task to e-mail me on failure. Is there a way of not letting a warning be a failure. ie warnings alone, no problem. I only want an email message on a real error, eg datafile missing, all rows failed to load, database full etc.

Oracle 816, OEM 2.1. Database on Solaris 2.7

TIA Received on Tue Apr 24 2001 - 15:13:58 CEST