10g SE, IOT table, block corruption
Dear community,
My DB is 10g Standard Edition and one of the database block in sysaux tablespace is corrupted. The block belongs to SYS.SYS_IOT_TOP_8829 index located on Index Organized Table SYS.AQ$_ALERT_QT_H.
If it were normal index I would be able to drop and create index to solve block corruption.
But it is index on IOT table located on PK and DB is 10g Standard Edition(Index cannot be rebuild online)... I am in trouble.
When I run:
1.
--Reorganize table to solve block corruption
alter table AQ$_ALERT_QT_H move;
--Error
ORA-08108: may not build or rebuild this type of index online