ORA-08104 for Oracle 10G

使用DBMS_REPAIR包修復

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(10);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
RAISE;
END;

參考網址：http://www.blogjava.net/decode360/archive/2009/07/30/292760.html

http://www.cnblogs.com/rootq/archive/2009/02/05/1384800.html

http://oracledba.spaces.live.com/blog/cns!57D0C396BA028F14!249.entry

[@more@]