Re: Can t get INSERT /*+ APPEND */ to indicate direct load in execution plan

From: Randolf Geist <>
Date: Wed, 02 Nov 2011 17:09:42 +0100
Message-ID: <>

The direct-path insert restriction with the non-unique index used to be there up to 10.2. It's no longer there in 11.1 and 11.2, however the change introduced another subtle (and nasty) questionable behaviour, see here:

It looks like this potential bug hasn't been addressed yet.


> Mark,
> Is your primary key protected by a non-unique constraint ? That would disable
> direct path load. Also, although you say you have no enabled FKs, the output
> you've shown does have an FK in ENABLE NOVALIDATE mode.
> Regards
> Jonathan Lewis

Received on Wed Nov 02 2011 - 11:09:42 CDT

Original text of this message