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
- 索引rebuild和rebuild online時要慎重索引Rebuild
- Index rebuild --case 1IndexRebuild
- 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索引
- index問題Index