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

ANKUSH THAVALI
03 Dec, 2023
0 Comments
35 Secs Read

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

Problem :


SQL> drop index eric_icmsprod.SOTRAN00_IDX1;
drop index eric_icmsprod.SOTRAN00_IDX1
*
ERROR at line 1:
ORA-08104: this index object 76154 is being online built or rebuilt

Solution :

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!