Re: Temporary space needed to create a constraint
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 11 Jul 2012 11:36:27 +0100
Message-ID: <CABe10sYeR47iVBaWf_RcLP_9z7jgVmKoE5k=vtmdu+JLzjNzNA_at_mail.gmail.com>
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_at_gmail.com>wrote:
Date: Wed, 11 Jul 2012 11:36:27 +0100
Message-ID: <CABe10sYeR47iVBaWf_RcLP_9z7jgVmKoE5k=vtmdu+JLzjNzNA_at_mail.gmail.com>
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_at_gmail.com>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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 11 2012 - 05:36:27 CDT