How to Use DBMS_REPAIR.ONLINE_INDEX_CLEAN For The Cleanup Of Online Index Failing With ORA-08104? (Doc ID 1378173.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 12.2.6 [Release 11.5.10 to 12.2]
Oracle Database - Enterprise Edition - Version 10.2.0.5 to 12.2.0.1 [Release 10.2 to 12.2]
Information in this document applies to any platform.

Goal

After terminating an Online index rebuild session and when you rebuild that index online for the second time, you get the following error :

ORA-08104: this index object ##### is being online built or rebuilt

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms