- 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