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

If you attempt to rebuild an entire index while rebuilding a partitioned index, you may receive an ORA-14086 error.

To solve the problem, rebuild all partitions separately.

Rebuild All Partition of a Partitioned Index

You can prepare the rebuild command for all partitions of the index with the following query.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *