RE: Can t get INSERT /*+ APPEND */ to indicate direct load in execution plan
Date: Wed, 2 Nov 2011 12:49:39 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F7B911279_at_AAPQMAILBX02V.proque.st>
Understood....it's just a bit unsettling that you can have an *enabled* constraint, and still get duplicate data into the table.
-Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Randolf Geist
Sent: Wednesday, November 02, 2011 12:42 PM
To: oracle-l_at_freelists.org
Subject: Re: Can t get INSERT /*+ APPEND */ to indicate direct load in execution plan
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 02 2011 - 11:49:39 CDT