Re: Can I add primary key constraint?

In article <8juad8$edg$1_at_nnrp1.deja.com>,   Carfield Yim <carfield_at_my-deja.com> wrote:
> 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.
>

well, the composite key (type, id) in your table is not unique, to enable a primary key the existing data in the given column(s) has to be unique. try to remove the duplicate instances and try the same command again.

hope that helps.

regards,

ATTA

--

getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.