ORA-08104: this index object 903237 is being online built or rebuilt異常終止的在線重建索引導致SMON進程沒有將索引的重建標志改回來,Oracle認為索引還在ONLINE REBUILD中，禁止刪除索引。--sysdbaDECLARE RetVal BOOLEAN; OBJECT_ID BINARY_INTEGER; WAIT_FOR_LOCK BINARY_INTEGER; BEGIN OBJECT_ID := 903237; WAIT_FOR_LOCK := NULL; RetVal := SYS.DBMS_REPAIR.ONLINE_INDEX_CLEAN (); COMMIT; END; /----ORdeclare done boolean; begin done:=dbms_repair.online_index_clean(903237); end;/
