Problem of a corrupted block on an IOT
I have a corrupted block in the sysaux tablespace :
ORA-01578: ORACLE data block corrupted (file # 3, block # 35516)
ORA-01110: data file 3: '/Data_Lifera_Fresco_Synchrony/AXWAYD/sysaux01.dbf'
The corrupted block is an index :
SQL> SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS WHERE 3 = FILE_ID AND 35516 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;
SEGMENT_TYPE
------------------
OWNER||'.'||SEGMENT_NAME
--------------------------------------------------------------------------------
INDEX
SYSMAN.MGMT_METRICS_RAW_PK
The problem is that I can't rebuild it :
SQL> alter index SYSMAN.MGMT_METRICS_RAW_PK rebuild tablespace SYSAUX;
ERROR at line 1:
ORA-28650: Primary index on an IOT cannot be rebuilt