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

  • From: Bill Coulam <bcoulam@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 13 Sep 2005 11:19:10 -0500

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.
 One can only rebuild the individual subpartitions, which I did. Now the 
data dictionary reports that the subpartitions are in the correct 
tablespace, but the partitions are not. Seems the only way is to drop and 
recreate them.

Has anyone out there found a way to move the partitions of a composite 
range-hash index without dropping and recreating them? Seems odd Oracle 
didn't cover this part of REBUILD.

-- 
bill coulam
bcoulam@xxxxxxxxx

Other related posts: