Re: index doesn't contain duplicates
Date: Tue, 9 Jun 2009 16:07:58 -0500
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-lReceived on Tue Jun 09 2009 - 16:07:58 CDT