Oracle database error code ORA-14086 – a partitioned index may not be rebuilt as a whole

Oracle Database Error Code ORA-14086 Description :
a partitioned index may not be rebuilt as a whole
Error Cause:
User attempted to rebuild a partitioned index using ALTER INDEX REBUILD statement, which is illegal

How to Solve :
Rebuild the index a partition at a time (using ALTER INDEX REBUILD PARTITION) or drop and recreate the entire index


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»