Home -> Usenet -> comp.databases.oracle -> How to create a descending index on the primary key.

How to create a descending index on the primary key.

From: Tuhin Kumar <tkumar_at_ipolicynet.com>
Date: 13 Dec 2003 05:56:26 -0800
Message-ID: <e4ad76f5.0312130556.63570b37_at_posting.google.com> 






Hi,


        Oracle give the error ORA-01418 when I try to do the
following;



Create unique index t1_pk on TABLE1(EntryId DESC) ;



If the I try to add primary key Contraint using the above index t1_pk
as below:


ALTER TABLE TABLE1 ADD CONSTRAINT TABLE1_PK PRIMARY KEY (EntryId)
USING INDEX t1_pk;



the following error comes "ORA-01418: specified index does not exist"
but the index t1_pk exists.



My requirement is to create a descending index on EntryId which gets
applied for all the queries.



Thanks


Tuhin
Received on Sat Dec 13 2003 - 14:56:26 CET












Original text of this message