- 03 Dec, 2023
- 0 Comments
- 35 Secs Read
ORA-08104: This Index Object Is Being Online Built Or Rebuilt
Problem :
1 2 3 4 5 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | Check the object_idSQL> select obj# ,name from obj$ where OBJ#=76154;OBJ# NAME---------- ------------------------------76154 SOTRAN00_IDX1--- Run dbms_repair for the object_idSQL> declarelv_ret BOOLEAN;beginlv_ret :=dbms_repair.online_index_clean(76154);end;/--- Verify whether index has been dropped or notSQL> select obj# ,name from obj$ where OBJ#=76154;no rows selected |