Re: SQL*LOADER

I use TRUNCATE(for bulk deletes) before my data loads.

IIFThen

Jérôme Poirier <poirier_at_gla.ecoledoc.lip6.fr> wrote in message news:7mnajv$dte$1_at_jaydee.iway.fr...
> (sorry, I don't speak english very well)
>
> Hello,
>
> I would like to use SQL*LOADER to put datas into a table, each day.
> I do : "c:\orant\bin\sqlldr73.exe userid=login/passwd_at_base control=data"
> It works great. But when I do this twice or more, the datas are appended,
> and not replaced. So the first time I have 90 records, the second time I
> have 180, and so on.
> How can I make SQL*LOADER replace datas with the news ? Is it done by
doing
> a primary key ?
>
> Thank you very much
> Jerome Poirier
> --
> poirier_at_gla.ecoledoc.lip6.fr
> http://gla.ecoledoc.lip6.fr/~poirier
>
>
>
>
>
>
Received on Sun Jul 18 1999 - 17:07:24 CEST