Re: Rebuild index partition with different compression number

From: ddf <oratune_at_msn.com>
Date: Tue, 7 Aug 2012 06:42:31 -0700 (PDT)
Message-ID: <795fd911-5d64-4665-95a0-1b2b7c20a79f_at_googlegroups.com>

On Tuesday, August 7, 2012 6:52:30 AM UTC-6, gonzo wrote:
> Hi, I am working with Oracle 10gR2.
>
>
>
> I have a list partitioned table on column "a" and a locally partitioned index with compression enabled:
>
>
>
> My_Table (a,b,c,d,.....) Partitions P1 and P2 on column "a" values.
>
>
>
> My_Index (b,c,d) non unique, compress 3, partitioned on "a".
>
>
>
> According to Index_stats view, the optimal compression would be 1, so I tried to rebuild my index with different compression executing:
>
>
>
> alter index My_Index rebuild partition P1 compress 1;
>
> *
>
> ERROR at line 1:
>
> ORA-14010: this physical attribute may not be specified for an index partition
>
>
>
> Does anyone have a clue of why I am getting this error?
>
> According to the documentation the above statement should be valid:
>
> http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_1008.htm#i2050158

Sorry, it shouldn't:

"Oracle Database compresses only nonpartitioned indexes that are nonunique or unique indexes of at least two columns."

That is quoted from the link you posted.

David Fitzjarrell Received on Tue Aug 07 2012 - 08:42:31 CDT