Wednesday, August 11, 2010

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

SQL> ALTER INDEX TEST_ID_IDX REBUILD;
ORA-14086: a partitioned index may not be rebuilt as a whole

Rebuilding a partitioned index is slightly different then rebuilding a normal (non-partitioned) index. So you should do this in the following way

SQL> ALTER INDEX TEST_ID_IDX REBUILD PARTITION TEST_2005;

No comments: