SQL*LOADER
From: (wrong string) érôme Poirier <poirier_at_gla.ecoledoc.lip6.fr>
Date: Fri, 16 Jul 1999 15:07:10 +0200
Message-ID: <7mnajv$dte$1_at_jaydee.iway.fr>
[Quoted] [Quoted] (sorry, I don't speak english very well)
Date: Fri, 16 Jul 1999 15:07:10 +0200
Message-ID: <7mnajv$dte$1_at_jaydee.iway.fr>
[Quoted] [Quoted] (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
[Quoted] Jerome Poirier
-- poirier_at_gla.ecoledoc.lip6.fr http://gla.ecoledoc.lip6.fr/~poirierReceived on Fri Jul 16 1999 - 15:07:10 CEST