ORA-14086: a partitioned index may not be rebuilt as a whole - Rebuilding PARTITION INDEX

SQL> ALTER INDEX SYS.WRH$_ACTIVE_SESSION_HISTORY_PK REBUILD TABLESPACE SYSAUX;

ALTER INDEX SYS.WRH$_ACTIVE_SESSION_HISTORY_PK REBUILD TABLESPACE SYSAUX

                *

ERROR at line 1:

ORA-14086: a partitioned index may not be rebuilt as a whole

            Check Partition indexes 

SQL> select Index_owner,Index_name,partition_name from dba_ind_partitions where index_name = 'WRH$_ACTIVE_SESSION_HISTORY_PK';


INDEX_OWNER                    INDEX_NAME                                             PARTITION_NAME
------------------------------ ------------------------------                                               ------------------------------
SYS                            WRH$_ACTIVE_SESSION_HISTORY_PK          WRH$_ACTIVE_4073093161_0
SYS                            WRH$_ACTIVE_SESSION_HISTORY_PK         WRH$_ACTIVE_SES_MXDB_MXSN


Rebuilding PARTITION INDEX

SQL> ALTER INDEX WRH$_ACTIVE_SESSION_HISTORY_PK  REBUILD PARTITION WRH$_ACTIVE_4073093161_0 TABLESPACE SYSAUX;

 Index altered.

 SQL> ALTER INDEX WRH$_ACTIVE_SESSION_HISTORY_PK REBUILD PARTITION WRH$_ACTIVE_SES_MXDB_MXSN  TABLESPACE SYSAUX;

 Index altered.

 


Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post