RE: Can t get INSERT /*+ APPEND */ to indicate direct load in execution plan
Date: Wed, 2 Nov 2011 17:14:54 +0000
And, fwiw, the behavior is the same on 22.214.171.124.0 on RH Linux 5.5.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Wednesday, November 02, 2011 10:50 AM To: info_at_www.sqltools-plusplus.org; oracle-l_at_freelists.org 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.
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
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.
> Wow, that's a nasty one, Randolf.
> Did you open SR with Oracle on this?
> If so, what did they say?
-- http://www.freelists.org/webpage/oracle-l -- http://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. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 02 2011 - 12:14:54 CDT