Re: ORA-00001 on non-unique index!

charles.a.berger_at_gmail.com wrote:

> Otherwise I'm thinking it must be a bug in Oracle, although a search of
> Metalink yesterday revealed no matches.
>
> Cheers,
>
> Charles.

Lets find out. Post the DDL for the table and all of its indexes and constraints so we can try it out in various versions. Be sure to indicate the version where you are finding the issue.

A few rows of sample data the produce any problem you think data related too if that is the case (can't remember).

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org