Re: index doesn't contain duplicates

From: Adric Norris <spikey.mcmarbles_at_gmail.com>
Date: Tue, 9 Jun 2009 16:07:58 -0500
Message-ID: <d4beff360906091407u4d66d7abq158c763127824da3_at_mail.gmail.com>



On Tue, Jun 9, 2009 at 1:11 PM, Josh Collier <Josh.Collier_at_banfield.net>wrote:

> Table was created with a CTAS
>
> Non-unique index was built
>
> Primary key was built on a column, specifying index created in step2.
> Enable novalidate. The data in question was inserted after the primary was
> in place.
>

Are you *absolutely* certain that the data wasn't preexisting? The combination of a nonunique index and novalidate on the PK constraint seems like it could easily explain the observed behavior.

-- 
"I'm too sexy for my code." - Awk Sed Fred.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 09 2009 - 16:07:58 CDT

Original text of this message