ORA-08104: this index object 93996 is being online built or rebuilt
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-08104: this index object %s is being online built or rebuilt的處理IndexObjectUI
- Online rebuild index遭遇ORA-08104RebuildIndex
- How to Determine When an Index Should be Rebuilt?IndexUI
- online rebulid index異常終止遇到ora-08104Index
- ORA-08104 索引online rebuild索引Rebuild
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- ORA-14086: a partitioned index may not be rebuilt as a wholeIndexUI
- create index .. onlineIndex
- create index onlineIndex
- Index Online RebuildIndexRebuild
- Create Index ...ONLINEIndex
- rebuild index online和create index online及沒有online的區別RebuildIndex
- create index/create index online區別Index
- How To Know If An Object (Table / Procedure / View /…) Is Currently BeingObjectView
- CREATE INDEX ......ONLINE分析Index
- Creating an Index OnlineIndex
- create index online 和create index 不同及注意點Index
- rebuild online被終止後的錯誤 ora-08104Rebuild
- alter index rebuild 與 rebuild onlineIndexRebuild
- index rebuild online的問題IndexRebuild
- 關於rebuild index online 及drop index後重建問題RebuildIndex
- MySQL online create index實現原理MySqlIndex
- Index online operation的過程 ztIndex
- 重建索引index rebuild online vs offline vs index coalesce vs index shrik space索引IndexRebuild
- 【羅玄】從鎖的角度看rebuild index online和rebuild indexRebuildIndex
- 聊聊索引Index Rebuild和Rebuild Online(下)索引IndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online(上)索引IndexRebuild
- alter index rebuild online引發的血案IndexRebuild
- ORA-08104@ONLINE_INDEX_CLEANIndex
- 測試index online rebuild故障記錄IndexRebuild
- alter index ... rebuild online的機制(zt)IndexRebuild
- “rebuild index online hang住" 問題解析RebuildIndex
- Creating an Index Online - 線上建立索引Index索引
- alter index ind1 rebuild 和alter index ind1 rebuild onlineIndexRebuild
- 建立index 使用Online導致的問題Index
- rebuild index online的鎖機制淺析RebuildIndex
- alter index rebuild和rebuild online的區別IndexRebuild