UNIQUE and PK

Hi,

I have a DB ( 7.3.2. AIX )
for some tables, i have
the constraints:
 NOT NUL, UNIQUE and PRIMARY KEY for the same column

How is it possible ????

If there a UNIQUE
when I try to put a PRIMARY KEY
I get:
ORA-02261 such unique or primary key already exists in the table

and the same for the reverse

How can you explain this situation ???

Thanks in advance Received on Wed Jul 24 2002 - 14:32:30 CDT