Re: Rebuilding Index on One Partition
You can do
ALTER TABLE cachelog REBUILD PARTITION p20081115
That will rebuild the partition, including the index.
For support of DISABLE KEY on partitioning level, please report a bug as feature request.
If only rebuilding of the index is needed (i.e. DISABLE/ENABLE KEY as one single statement), that is easier to implement per partition then keeping the DISABLE/ENABLE KEY status between statments, so please include that in the bug report/feature request.
Subject
Views
Written By
Posted
4805
November 20, 2008 06:07AM
Re: Rebuilding Index on One Partition
3449
December 11, 2008 07:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.