ORA-08104: this index object 93996 is being online built or rebuilt

why566發表於2010-07-08

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;

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7478833/viewspace-667596/,如需轉載,請註明出處,否則將追究法律責任。

相關文章