Re: 11.2 change in direct insert behavior

From: Jonathan Lewis <>
Date: Sun, 26 Feb 2012 17:45:18 -0000
Message-ID: <>

| Jonathan, sorry for being unclear. The change is with the "values" form,
| as in the mentioned MOS document:


I see that Charles has already responded with a link to Christian's article about append and append_values.
I'm always a little torn about assigning blame to Oracle when someone does something that they're not supposed to, and then find that it breaks. I can imagine a sequence of events like this at Oracle Corp::

  1. we need to allow direct path insert for values - let's make the append hint work, no-one will be using it the wrong way
  2. complaints of bugs pop up from people who have been using the append hint incorrectly in the past
  3. Oracle introduces append_values for people who really need to append values so that they don't have to run two lines of code for one hint.depending on the circumstances where it's used.

Jonathan Lewis
Oracle Core (Apress 2011)

"Mladen Gogala" <> wrote in message

| On Sat, 25 Feb 2012 22:48:10 +0000, Jonathan Lewis wrote:
| > Are you sure this is a change - as far as I can recall there has always
| > been a TM mode 6 on "insert /*+ append */"
| Version:
Received on Sun Feb 26 2012 - 11:45:18 CST

Original text of this message