ora-08104
时间：2010-08-03 来源：drew
今天有个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
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
相关阅读 更多 +
