index rebuild online的問題
意外cancel掉了一個正在rebuild的索引,單Smon並沒有及時清理rebuild索引時建立的臨時物件(sys.ind$等),否則再操作的時候會報錯:ora-08104
10g開始可以使用dbms_repair.online_index_clean來清除
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16179598/viewspace-750086/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- “rebuild index online hang住" 問題解析RebuildIndex
- 關於rebuild index online 及drop index後重建問題RebuildIndex
- Index Online RebuildIndexRebuild
- alter index rebuild 與 rebuild onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- alter index rebuild和rebuild online的區別IndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online(下)索引IndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online(上)索引IndexRebuild
- 【羅玄】從鎖的角度看rebuild index online和rebuild indexRebuildIndex
- rebuild index online和create index online及沒有online的區別RebuildIndex
- alter index ind1 rebuild 和alter index ind1 rebuild onlineIndexRebuild
- alter index rebuild online引發的血案IndexRebuild
- alter index ... rebuild online的機制(zt)IndexRebuild
- rebuild index online的鎖機制淺析RebuildIndex
- 測試index online rebuild故障記錄IndexRebuild
- Online rebuild index遭遇ORA-08104RebuildIndex
- 重建索引index rebuild online vs offline vs index coalesce vs index shrik space索引IndexRebuild
- 建立index 使用Online導致的問題Index
- rebuild indexRebuildIndex
- index rebuildIndexRebuild
- "Alter index rebuild online parallel n"會修改索引的degree屬性IndexRebuildParallel索引
- oracle10g_alter index rebuild_online_重構索引OracleIndexRebuild索引
- (轉)Index Rebuild Online 過程(9i)完整版IndexRebuild
- rebuild index 排序RebuildIndex排序
- sybase rebuild indexRebuildIndex
- ORACLE中index的rebuildOracleIndexRebuild
- rebuild與rebuild online效率比對Rebuild
- best practice of rebuild your partition table local index online by using: "update indexes"RebuildIndex
- Index rebuild --case 1IndexRebuild
- 索引rebuild和rebuild online時要慎重索引Rebuild
- alter index rebuild與index_statsIndexRebuild
- rebuild index 和 recreate index (重新建立index) 的區別RebuildIndex
- 索引rebuild和rebuild online時要慎重(轉載)索引Rebuild
- Oracle alter index rebuild 說明OracleIndexRebuild
- 大資料量rebuild index的經歷大資料RebuildIndex
- create index , rebuild index troubleshooting 索引故障解決IndexRebuild索引
- create index .. onlineIndex