Re: Primary key question

In article <84311b23-2549-4323-acba-56bcee7781ec_at_1g2000hsl.googlegroups.com>, "fitzjarrell_at_cox.net" <fitzjarrell_at_cox.net> wrote: [...]
>
>SQL> create table abc(
> 2 a varchar2(8),
> 3 b varchar2(8),
> 4 c varchar2(8));
>
>Table created.
>
>SQL> create index abc_ind
> 2 on abc(a, b, c desc)
> 3 /
>
>Index created.
>
>SQL> alter table abc
> 2 add constraint abc_pk
> 3 primary key(a,b,c)
> 4 using index abc_ind;
>alter table abc
>*
>ERROR at line 1:
>ORA-14196: Specified index cannot be used to enforce the constraint.

Thanks. Received on Wed Feb 13 2008 - 09:10:59 CST