Re: Can I add primary key constraint?

The error just means your data is shitty. You'll need to resolve that first.

Hth,

Sybrand Bakker, Oracle DBA

"Carfield Yim" <carfield_at_my-deja.com> wrote in message news:8juad8$edg$1_at_nnrp1.deja.com...
> 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