Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> compressing primary key indexes
Howdy,
I currently have a large partitioned table (>2billion rows). The
primary key for this table consists of 3 columns, the leading 2 would
be perfect for compression (duplicated anywhere from 50 to 500 times).
The catch, you can't put a "compress 2" in the alter table add
constraint clause. Oracle gives:
ORA-14071: invalid option for an index used to enforce a constraint
I've tried rebuilding the index behind this constraint with the
compress clause and it complains as well.
Can this be done? Is it the primary key constraint that's blocking
it or the fact that the table (and thus index) are partitioned? Or
could it be that the partitioning column (date) is the 2nd column in
the primary key?
Thanks for any response
John. Received on Thu Sep 06 2001 - 16:13:13 CDT