Re: How to REPLACE a unique field?

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Fri, 12 Mar 2004 12:17:52 -0600
Message-ID: <bkv3509ptjnhrn7vno811pe2esnjqij4jk@4ax.com>

ramon_at_conexus.net (Ramon F Herrera) wrote:

>"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<09SdnaJoyrFGidLdRVn-uQ_at_comcast.com>...
>> what tool are you using to load the data? (sounds like oracle loader, but
>> please confirm)
>>
>> what version of the database?
>>
>> the MERGE (9i) statement may help, but only if you're loading data from a
>> table
>>
>> ;-{ mcs
>
>
>I am using SQL*Loader (sqlldr under Solaris and Linux).
>Version is 9iR2.
>
>-Ramon

Given that, probably , as was suggested, the best way is to load into a 'holding' table then process ( with MERGE maybe) Received on Fri Mar 12 2004 - 12:17:52 CST