Re: Relocating the partitions of an index on a composite partitioned table.

Actually I just went through this exercise. With composite partitioned indexes, you need to do a drop and create. Rebuild will not work.

Rodd

Deepak Sharma wrote:

>We noticed this too. It seems odd, but it is perfectly
>normal. The granularity of a composite partitioned
>table is the subpartition. If you rebuild 'ALL' the
>subpartitions of a partition in a different
>tablespace, you should be OK, since the partition
>itself does not contain any data, its subpartition(s)
>has the data.
>
>
>- Deepak
>
>--- Bill Coulam <bcoulam_at_gmail.com> wrote:
>
>
>
>>It turns out that one *cannot rebuild* (and
>>therefore relocate as well) the
>>partitions of a composite partitioned index. If you
>>try, you get
>> ORA-14287: cannot REBUILD a partition of a
>>Composite Range partitioned
>>index
>> The Oracle docs confirm:
>> The ALTER INDEX ... REBUILD PARTITION statement
>>rebuilds one partition of
>>an index. It cannot be used on a range-hash
>>partitioned table.
>>
>>
>
>
>
>
>__________________________________
>Yahoo! Mail - PC Magazine Editors' Choice 2005
>http://mail.yahoo.com
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
rodd.holman_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l