Re: MERGE statement not working with use of hints

"What's in a namespace" <xml_at_ns.com> schreef in bericht news:45793822$0$337$e4fe514c_at_news.xs4all.nl...
>
> "Dereck L. Dietz" <dietzdl_at_ameritech.net> schreef in bericht
> news:pc3eh.20172$9v5.12764_at_newssvr29.news.prodigy.net...
>> The following code has been written under Oracle 10g R2.
>>
>> The first merge statement
>> will insert rows into the stg_provider table. However, if any hint at
>> all
>> is used
>> nothing will be written. I have other procedures using merge statements
>> with hints
>> which work just fine. Any suggestions on where I should look would be
>> appreciated.
>>
>>
>> MERGE INTO stg_provider a
>>
>> MERGE /*+ APPEND */ INTO stg_provider a
>>
>
> From AskTom: the conclusion was:
>
> <quote>
> actually, hmmm, i just tested without parallel dml and sure enough, the
> APPEND
> hint does in fact modify the behaviour of the MERGE, interesting -- every
> time I
> answer something with a test case to back it up, I goof.
> <unquote>
>
> so it seems that merge and append do not go together very well.
>
> Shakespeare
>
>
>

With AskTom working again, and not reading from the Google cache I found this:
<quote>

Reviewer: Su Baba

Can /*+ APPEND */ hint be used with MERGE?

      Followup:
yes, the insert component of a merge can be done in append mode.

<unquote>

from which one may conclude that the + APPEND hint should be in the insert part, not in the MERGE part. Received on Fri Dec 08 2006 - 06:42:52 CST