Re: SQL*LOADER
From: Chumley <mschumle_at_willscot.com>
Date: Fri, 16 Jul 1999 13:10:15 -0400
Message-ID: <7mnp28$lm8$1_at_paxfeed.eni.net>
Date: Fri, 16 Jul 1999 13:10:15 -0400
Message-ID: <7mnp28$lm8$1_at_paxfeed.eni.net>
IN the control file you can use the parameter to either APPEND/REPLACE/INSERT. Use the REPLACE option. The documentation has more on this.
-- Mike Chumley Oracle DBA Williams Scotman Jérôme Poirier <poirier_at_gla.ecoledoc.lip6.fr> wrote in message news:7mnajv$dte$1_at_jaydee.iway.fr...Received on Fri Jul 16 1999 - 19:10:15 CEST
> (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
>
>
>
>
>
>