RE: Can t get INSERT /*+ APPEND */ to indicate direct load in execution plan
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: "Mark.Bobak@xxxxxxxxxxxx" <Mark.Bobak@xxxxxxxxxxxx>, "info@xxxxxxxxxxxxxxxxxxxxxxxxx" <info@xxxxxxxxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Nov 2011 17:14:54 +0000
And, fwiw, the behavior is the same on 11.2.0.2.0 on RH Linux 5.5.
-joe
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bobak, Mark
Sent: Wednesday, November 02, 2011 10:50 AM
To: info@xxxxxxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Can t get INSERT /*+ APPEND */ to indicate direct load in
execution plan
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Randolf Geist
Sent: Wednesday, November 02, 2011 12:42 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT Managers,
LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for
viruses, it does not guarantee that either are virus-free and accepts no
liability for any damage sustained as a result of viruses. Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
