ORA-08104: This Index Object Is Being Online Built Or Rebuilt

Question

OracleDba · Accepted Answer

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

Check the object_id

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

OBJ# NAME

---------- ------------------------------

76154 SOTRAN00_IDX1

--- Run dbms_repair for the object_id

SQL> declare

lv_ret BOOLEAN;

begin

lv_ret :=dbms_repair.online_index_clean(76154);

end;

/

--- Verify whether index has been dropped or not

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

no rows selected

Hope it Helps!

Solutions(1)