Re: MERGE statement not working with use of hints

From: What's in a namespace <xml_at_ns.com>
Date: Fri, 8 Dec 2006 11:01:54 +0100
Message-ID: <45793822$0$337$e4fe514c@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 Received on Fri Dec 08 2006 - 04:01:54 CST