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

From: Randolf Geist <info_at_www.sqltools-plusplus.org>
Date: Wed, 02 Nov 2011 17:42:04 +0100
Message-ID: <4EB172DC.nailFPS1FT876_at_sqltools-plusplus.org>



Hi Mark,

good question - it's quite a while ago - and I think to remember since this was not part of a client's problem I didn't open a SR.

Note though that the duplicates are only possible when the non-unique index supporting the PK is in unusable state. Under normal circumstances everything is fine.

Randolf

> Wow, that's a nasty one, Randolf.
>
> Did you open SR with Oracle on this?
>
> If so, what did they say?
>
>
> Nasty.....
>
>
> -Mark

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 02 2011 - 11:42:04 CDT

Original text of this message