Curious as to what your rationale for the non-unique index is? Do you drop and recreate the constraint frequently but want to keep the index? On Wed, Jul 11, 2012 at 11:13 AM, Peter Hitchman <pjhoraclel@xxxxxxxxx>wrote: > Hi > Thanks for the comments. I forgot to say I think that the index I > created is non-unique. -- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l