Re: conditional unique index to restrict duplicates of a particular set

From: Mohamed Houri <mohamed.houri_at_gmail.com>
Date: Wed, 7 May 2014 15:50:46 +0200
Message-ID: <CAJu8R6hQ3GchLto1WDsXARuY=8gxaQgjYZ=BwZDO2Btmeu5FGw_at_mail.gmail.com>

I am wondering how you will be able to enforce uniqueness via a trigger in a multi-user concurent application? It will not scale. You need either to use your unique function based index or, if in 11gR1 and up create a virtual column and place a unique constraint (unique index) on this virtual column

Best regards
Mohamed Houri

2014-05-07 15:13 GMT+02:00 Fergal Taheny <ftaheny_at_gmail.com>:

> Hi Carlos,
>
> Won't you face a mutating table error if you try to use a trigger for this.
>
> Regards,
> Fergal
>

-- 
Bien Respectueusement
Mohamed Houri

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 07 2014 - 15:50:46 CEST