Re: ORA-00001: unique constraint violated

screwbai_at_my-deja.com a écrit :

> I figure out this problem. One of the column had a NULL in it. And NULLs
> are not allowed in a unique index.

Not true as much as Oracle is engaged! I knew it but I have done the following on Oracle 8.1.6

create table essai (a integer, b integer, c char(1)); create unique index uind on essai(a,b);
insert into essai values(null, null, 'a'); insert into essai values (null, null, 'b'); insert into essai values(1, null, 'c');

All of these instructions completed with no problem.

--
Mohamad