Re: How to create a uniqueness constraint based on two fields?

From: Thomas Kellerer <NNGNVRDSJEBN_at_spammotel.com>
Date: Thu, 27 Jan 2005 08:22:45 +0100
Message-ID: <35rj66F4pms4qU1@individual.net>

On 26.01.2005 19:33 DA Morgan wrote:

>> CREATE UNIQUE INDEX ON the_table (first_name, last_name);
>>
>> should do it, I guess.
>>
>> Thomas

>
>
> While your answer is technically correct there is almost not good
> reason for ever creating a unique index in Oracle. Unique indexes,
> unlike unique constraints are not as well documented in the data
> dictionary and can't be deferred.

Interesting, I didn't know that.

Could you more be more detailed on what you mean with "can't be deferred"?

Thanks
Thomas Received on Thu Jan 27 2005 - 01:22:45 CST