how to rebuild sysman.MGMT_METRICS_RAW_PK index?
RDBMS 11.2.0.4 EE on Oracle Linux 6.10
My SYSAUX TABLESPACE has 2 Gb of size.
Checking objects and size the sysman.MGMT_METRICS_RAW_PK index is the largest object on SYSAUX TABLESPACE.
Trying to rebuild the index fail with.
SQL> alter index sysman.MGMT_METRICS_RAW_PK rebuild;
alter index sysman.MGMT_METRICS_RAW_PK rebuild
*
ERROR at line 1:
ORA-28650: Primary index on an IOT cannot be rebuilt
0