[μ€λΌν΄/oracle] ORA-14086: a partitioned index may not be rebuilt as a whole
μΈλ±μ€μ ν μ΄λΈμ€νμ΄μ€λ₯Ό λ³κ²½νκΈ°μν΄μ μλμ κ°μ 쿼리λ₯Ό λ λ Έλλ μ λͺ©μ μ°μΈ μ€λ₯κ° λ¬λ€.
SQL> alter index μΈλ±μ€λͺ rebuild tablespace ν μ΄λΈμ€νμ΄μ€λͺ ;
μ΄μ μΈμ¦μ¨ μΈλ±μ€κ° νν°μ λμ΄ λμ΄λ²λ €μ νλ²μ rebuildν μ μλ€λ μκΈ°
ν΄λΉ μΈλ±μ€κ° νν°μ λμ΄ λμ΄μλμ§λ μλμ κ°μ λͺ λ Ήμ΄λ‘ νμΈν μ μλ€.
SQL> select index_name,partitioned from dba_indexes where partitioned='YES' and table_name='ν μ΄λΈλͺ ';
μ κ·ΈλΌ μ΄λ»κ² ν΄μΌν κΉ?? μΈλ±μ€κ° νν°μ λμ΄ λμλ€λ μκΈ°λ ν μ΄λΈμ΄ νν°μ λμ΄ λμ΄μλ€λ μκΈ°κ°μλ°....κ·ΈλΌ μ΄μ μ΄ μΈλ±μ€κ° μ΄λ νν°μ μμ μ¬μ©μ΄ λλμ§ νμΈν΄μ κ° νν°μ λ³λ‘ μΈλ±μ€λ₯Ό rebuildνλ©΄ λ κ² κ°μλ°??
μ°μ μ΄ μΈλ±μ€κ° μ΄λ νν°μ μμ μ¬μ©λλμ§ νμΈν΄λ³΄μ.
SQL> select index_name, partition_name from dba_ind_partitions where index_name='μΈλ±μ€λͺ ';
INDEX_NAME PARTITION_NAME
------------------------------ ------------------------------
EE ARCH_STATE
EE CURR_STATE
EE PREV_STATE
κ·Έλ¦¬κ³ κ° νν°μ μ λν΄μ μΈλ±μ€λ₯Ό rebuildνμ.
SQL> alter index ee rebuild partition ARCH_STATE;
Index altered.
SQL> alter index ee rebuild partition CURR_STATE;
Index altered.
SQL> alter index ee rebuild partition PREV_STATE;
Index altered.
κ²μ μ€λ°~!!
alter index ee rebuild partition ARCH_STATE;