Rebuilding Database Index with Partition (ORA-14086)

Needed to rebuild index on a Oracle Database but because the table was partitioned, we could not use the normal command of:-

ALTER INDEX [INDEX NAME] REBUILD ONLINE;

and had some error below:-

ORA-14086: a partitioned index may not be rebuilt as a whole

The next step was to find out the partition name so that we can rebuild base on the partition

select index_name, partition_name from user_ind_partitions where index_name = '[INDEX NAME]';

After you get the partition name, you simply need include that

ALTER INDEX [INDEX NAME] REBUILD PARTITION '[PARTITION NAME]' ONLINE;

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.