重建索引報ORA-14086錯誤
1 重建索引報錯
SYS@test2 >alter index user02.PK_E_TAB_PAR rebuild online tablespace TBS001 parallel 8 ;
alter index user02.PK_E_TAB_PAR rebuild online tablespace TBS001 parallel 8
*
ERROR at line 1:
ORA-14086: a partitioned index may not be rebuilt as a whole
2 檢視官方的報錯資訊,讓根據分割槽名稱進行重建
[oracle@yxjcptdb3 ~]$ oerr ora 14086
14086, 00000, "a partitioned index may not be rebuilt as a whole"
// *Cause: User attempted to rebuild a partitioned index using
// ALTER INDEX REBUILD statement, which is illegal
// *Action: Rebuild the index a partition at a time (using
// ALTER INDEX REBUILD PARTITION) or drop and recreate the
// entire index
3 檢視官方文件
ORA-14086 When Rebuilding Index Of Partition Table (Doc ID 2403717.1)
APPLIES TO:
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
SYMPTOMS
RDBMS version 11.2.0.4 onwards
When trying to rebuild an partition index, ORA-14086 error is spotted
CHANGES
No changes
CAUSE
This issue is essentially a syntax error and following correct syntax resolve this ORA-14086 error.
SOLUTION
Step 1: Look-up the partition name in dba_ind_partitions view.
Step 2: specify the partition name in the index rebuild statement:
4 查詢分割槽名稱
OWNER SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME SEGMENT_TYPE TRUNC(SUM(BYTES)/1024/1024/1024)
-------------------- ---------------------------------------- -------------------- -------------------- -------------------- --------------------------------
user02 PK_E_TAB_PAR E_TAB_PAR20190101 TBS_01 INDEX PARTITION 13
5 根據分割槽名稱,重新重建索引,成功,如下:
SYS@test2 >alter index user02.PK_E_TAB_PAR rebuild partition E_TAB_PAR20190101 online tablespace
TBS001 parallel 8 ;
Index altered.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/69996316/viewspace-2894999/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 重建索引索引
- 索引重建索引
- oracle重建索引(一)Oracle索引
- oracle重建索引(三)Oracle索引
- oracle重建索引(二)Oracle索引
- MSSQL Rebuild(重建)索引SQLRebuild索引
- 匿名類 與 索引重建索引
- 清理重建失敗的索引索引
- SQL Server 2014的重建索引SQLServer索引
- mysql 索引長度 767 錯誤 ERROR 1071MySql索引Error
- 教你如何在 elasticsearch 中重建索引Elasticsearch索引
- HugeGraph之索引重建和刪除索引
- 如何在Mac上重建Spotlight索引Mac索引
- 從渲染流程解說Flutter老鳥也常犯的錯誤——多次重建Flutter
- oracle 報大小寫錯誤Oracle
- dbfread報錯ValueError錯誤解決方法Error
- 新手必看:如何在Mac上重建Spotlight索引Mac索引
- sqlserver索引重建和索引重組的區別和操作方法SQLServer索引
- 使用antd報less的錯誤
- 【TUNE_ORACLE】索引定期重建的利與弊Oracle索引
- LOB欄位相關概念(自動建立LOB索引段和重建索引方法)索引
- ORA-01658建立表或索引報錯分析索引
- 前端錯誤監控與上報前端
- react元件內報implementation()方法錯誤!React元件
- navicat 建立事件報語法錯誤事件
- Elasticsearch報Call to undefined xx makeAllSearchable()錯誤ElasticsearchUndefined
- linux安裝thefuck報gcc錯誤LinuxGC
- 解決遷移資料庫錯誤,索引長度過長資料庫索引
- MySQ索引操作命令總結(建立、重建、查詢和刪除索引命令詳解)索引
- org.thymeleaf.exceptions.TemplateInputException:模板錯誤報錯問題Exception
- Oracle 條件索引 case when 報錯解決方案Oracle索引
- Qt報Multiple definition錯誤的解決QT
- laravel mysql批量提交報Access denied 錯誤LaravelMySql
- mysql報1045錯誤是什麼意思MySql
- Elasticsearch 叢集和索引健康狀態及常見錯誤說明Elasticsearch索引
- 對SQLServer錯誤使用聚集索引的優化案例(千萬級資料量)SQLServer索引優化
- ef8 Contains 查詢條件 報錯 $ 附近錯誤AI
- 【常見錯誤】--Nltk使用錯誤