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

From: Bill Coulam <bcoulam_at_gmail.com>
Date: Tue, 13 Sep 2005 11:19:10 -0500
Message-ID: <f51d330205091309191a5c58c@mail.gmail.com>

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_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 13 2005 - 11:21:10 CDT