FreeLists / oracle-l / Re: Relocating the partitions of an index on a composite partitioned table.

[Rodd Holman <Rodd.Holman@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx

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