Re: How to REPLACE a unique field?

Ramon F Herrera wrote:

> Thanks for your answer, VC.
>
> I should clarify that I am using SQL*Loader to fill
> a table which is originally empty. The *.dat file
> contains many records which violate the unique constraint
> and I would like to do a replacement in those cases,
> instead of the first one being accepted, I'd like to
> have the last one.
>
> TIA,
>
> -Ramon

How much data are we talking about and in what version of Oracle?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)