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 to 12.2.6 [Release 11.5.10 to 12.2]
Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.2]
Information in this document applies to any platform.


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


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