ORA-08104 error received during index rebuild process


During the process of an online index rebuild operation, when the related session is unexpectedly interrupted, even though there is no rebuild process, it seems that like the rebuild process is still in progress.

For this reason, it is caused ORA-08104 error when trying to perform the rebuild process again.

Rebuild process ends with error as follows.

You can resolve this problem by running the dbms_repair.online_index_clean function.

Example use is as follows:

You must type the problematic index id instead of index_object_id. You can access this information from dba_objects, user_indexes or all_indexes. You need to connect and run with SYS.

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 *