Re: compressing primary key indexes

When all else fails, create the index, then add the constraint. There is no inherent reason why you can't do what you want
to do - probably some minor detail of
irritating syntax.

BTW Given that this is a very large table, you may want to create the index 'unusable' then rebuild it partition by partition.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.