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.
