Re: sqlldr and discarded records

Christoph Seidel wrote:
> Alistair Thomson wrote:
>> Hi
>>
>> Use the .bad file as the new source file, after you've resolved the
>> issues why the records weren't posted the first time around.
>
> but what about the imput file? some records were already imported,
> some not
> (not in bad file).
> How do i prevent that the already imported files get re-imported?
>

Hello Christoph,

in your loader control file you can specify a badfile and a discardfile the latter receiving the discarded rows. So after your load you can process the discardfile instead of your input file. Obviously you have to adust your loader control file or the rows will be discarded again.
Since the discardfile only contains discarded rows, there is no danger to load some rows twice.

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de