ORA-14086: a partitioned index may not be rebuilt as a whole
SQL> alter index SDSETTLE.UN_PK_STLGPRSCNGKEY rebuild online parallel 16;
alter index SDSETTLE.UN_PK_STLGPRSCNGKEY rebuild online
*
ERROR at line 1:
ORA-14086: a partitioned index may not be rebuilt as a whole
正常重建分割槽索引的是:
alter index SDSETTLE.UN_PK_STLGPRSCNGKEY rebuild partition KEY20150418_0 online parallel 16;
alter index SDSETTLE.UN_PK_STLGPRSLTECNGKEY rebuild partition KEY20150418_0 online parallel 16;
alter index SDSETTLE.UN_PK_STLGPRSCNGKEY rebuild online
*
ERROR at line 1:
ORA-14086: a partitioned index may not be rebuilt as a whole
正常重建分割槽索引的是:
alter index SDSETTLE.UN_PK_STLGPRSCNGKEY rebuild partition KEY20150418_0 online parallel 16;
alter index SDSETTLE.UN_PK_STLGPRSLTECNGKEY rebuild partition KEY20150418_0 online parallel 16;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29446986/viewspace-1584816/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to Determine When an Index Should be Rebuilt?IndexUI
- Partitioned Index-Organized Tables (234)IndexZed
- [20171211]UNIQUE LOCAL(Partitioned)IndexIndex
- ORA-08104: this index object 93996 is being online built or rebuiltIndexObject996UI
- ORA-08104: this index object %s is being online built or rebuilt的處理IndexObjectUI
- cornerstone the server may be unreachable or the url may be incorrectServer
- Oracle Partitioned TablesOracle
- Overview of Partitioned IndexesViewIndex
- Local Partitioned IndexesIndex
- Convert Range-Partitioned Table To Interval-Range-Partitioned Table
- It's not even the whole quest. In this article
- partitioned by timestamp datatype
- Global Range Partitioned IndexesIndex
- Global Hash Partitioned IndexesIndex
- Maintenance of Global Partitioned IndexesAINaNIndex
- Partitioned Tables (165)
- Making Whole Database Backups with RMANDatabase
- Create Reference-Partitioned Tables
- Partitioned Indexes on Composite PartitionsIndex
- Oracle 12c RMAN Duplicating the Whole CDBOracle
- Oracle Partitioned Table:exchange的利用Oracle
- How to partition a non-partitioned table
- Bitmap Indexes on Partitioned Tables (225)Index
- March - May 做題合集
- Using Partitioned Indexes in OLTP ApplicationsIndexAPP
- Ten Principles of Economics__How The Economy as a Whole Works
- Row Movement Common Questions and Problems on Partitioned Tables
- Gradle's dependency cache may be corruptGradle
- FAQ: Row Movement Common Questions and Problems on Partitioned Tables
- Miscellaneous Information about Creating Indexes on Partitioned TablesORMIndex
- The DBA_TABLESPACE_USAGE_METRICS View Needs to be Rebuilt in 10g_738101.1ViewUI
- KEEP INDEX | DROP INDEXIndex
- Oracle 12C RMAN Duplicating the Whole RAC CDB to local RAC CDBOracle
- VB.Net中文教程(13) Whole-Part關係 (轉)
- TiKV 新架構:Partitioned Raft KV 原理解析架構Raft
- Using Partitioned Indexes in Data Warehousing and DSS ApplicationsIndexAPP
- 使用Partitioned Outer Join實現稠化報表
- SQL Server 表分割槽(partitioned table/Data Partitioning)SQLServer