ora-08104

今天有个index ,create 加online后，建索引时间太长，我就中断了。没想到，后来这个索引drop不掉。

 

报

rac1> ALTER INDEX test.t_test_idx rebuild;
ALTER INDEX test.t_test_idx rebuild
*
ERROR at line 1:
ORA-08104: this index object 64756 is being online built or rebuilt

 

DECLARE
 isClean BOOLEAN;
BEGIN
  isClean := FALSE;
  WHILE isClean=FALSE
  LOOP
    isClean := dbms_repair.online_index_clean(dbms_repair.all_index_id, dbms_repair.lock_wait);
    dbms_lock.sleep(5);
  END LOOP;
END;

 

 

结果就正常了。感谢yxy