SQL> alter index  IN_CLIPINFO_PATH rebuild online;
alter index IND_TEST_ID rebuild online
*
ERROR at line 1:
ORA-08104: this index object 93996 is being online built or rebuilt

select object_id,status from dba_objects where object_name=upper('IN_CLIPINFO_PATH');

Oracle10g可以用这种方法

 DECLARE
 RetVal BOOLEAN;
 OBJECT_ID BINARY_INTEGER;
 WAIT_FOR_LOCK BINARY_INTEGER;
 BEGIN
 OBJECT_ID := 57394;
 WAIT_FOR_LOCK := NULL;
 RetVal := SYS.DBMS_REPAIR.ONLINE_INDEX_CLEAN ();
 COMMIT;
 END;
/

 alter index  IN_CLIPINFO_PATH rebuild online nologging;