Re: Sql Loader

csrazdan wrote:
> Hi Guys...
> I am loading data from a flat file into a table. Everything is running
> fine. I receive a file as full refresh or partial refresh. In case of
> partial refresh only the new records are being send from the last load
> and so no problem comes. In case of an full refresh, the older records
> are also send from the last load and so the records get rejected due to
> PK violations on the table. Till now everything is okay.
> But what I want is that rather than rejecting the recods due to insert
> statement I want the record to be updated with the new value. Is there
> any way in which CTL file can handle INSERT and UPDATES on the table on
> the same time.
> Any suggestions in this regard will be appericiated.
> If you require more input please send me a mail on
> csrazdan_at_indiatimes.com
>
> Regards,
> Shekhar
>
> --
> Posted via http://dbforums.com
Maybe I'm missing your point, but Tom Kyte covers this in Chap 9 of his Oracle expert one-on-one book ... so ... I'll bet it's also on his web site: http://asktom.oracle.com (searchable treasure trove). Received on Thu Jan 16 2003 - 01:48:45 CET