Re: SQL*Loader: create bad-file
From: Zafer <zafer_at_redshift.com>
Date: Thu, 22 May 2003 20:20:54 -0700
Message-Id: <pan.2003.05.23.03.20.54.3317_at_redshift.com>
Date: Thu, 22 May 2003 20:20:54 -0700
Message-Id: <pan.2003.05.23.03.20.54.3317_at_redshift.com>
On Tue, 06 May 2003 01:55:56 -0700, Konni wrote:
> Is it possible to create a bad-file for every LOAD with the SQL*Loader
> (not only for rejected or bad records).
> I use the oracle-Workflow to load the flat-file. That happens every
> two hours.
> And the bad-file is loaded in another Table, too. And if one Load have
> not created a new Bad-File the old one is loaded.
> So every Load have to create a bad-File, which contains rejected
> Records or NOTHING.
>
> I hope you understand the problem ;-)
sqlldr creates a bad file and a log file as you know. How you process these 2 files is up to your shell scripting skills. Received on Fri May 23 2003 - 05:20:54 CEST