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
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;
Tags:
Oracle