Can I add primary key constraint?

From: Carfield Yim <carfield_at_my-deja.com>
Date: 2000/07/05
Message-ID: <8juad8$edg$1@nnrp1.deja.com>#1/1

When I use the following SQL command to add primary key constraint:

alter table deletelog add constraint pk_deletelog primary key
(type, id) using index tablespace renren_idx

I receive the following error message:

SQL> alter table deletelog add constraint pk_deletelog primary key(type, id);
alter table deletelog add constraint pk_deletelog primary key
(type, id) using index

*
ERROR at line 1:
ORA-02437: cannot enable (RENREN.PK_DELETELOG) - primary key violated

How can I add primary key constraint?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 05 2000 - 00:00:00 CDT