While rebuilding an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair

Problem:

SQL> alter index sapr3."ZJDADEMAND~0" rebuild online;

alter index sapr3."ZJDADEMAND~0" rebuild online

*

ERROR at line 1:

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

Solution:

— check the object_id

SQL> select obj# ,name from obj$ where OBJ#=229469;

OBJ# NAME

———- ——————————

229469 ZJDADEMAND~0

— Run dbms_repair for the object_id

SQL>SQL> declare

lv_ret BOOLEAN;

begin

lv_ret :=dbms_repair.online_index_clean(229469);

end;

/  2    3    4    5    6

PL/SQL procedure successfully completed.

— Verify whether index has been dropped or not

SQL> select obj# ,name from obj$ where OBJ#=229469;

no rows selected.