Re: conditional unique index to restrict duplicates of a particular set
- From: Mohamed Houri <mohamed.houri@xxxxxxxxx>
- To: ftaheny@xxxxxxxxx
- Date: Wed, 7 May 2014 15:50:46 +0200
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@xxxxxxxxx>:
> 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
Other related posts:
