I am getting a "ORA-01578: ORACLE data block corrupted " error in my database. My research into this has shown the error to be in the MGMT_METRICS_RAW table, more specifically the PK for this table. But since it is an index organized table, the PK is basically the table itself. I cannot run the DBMS_REPAIR utility on an indexed organized table, so my choice seems to be to salvage what I can from the table, drop, then recreate.
Are there any problems/dangers in dropping/recreating this table? It seems to be a monitoring table, I can salvage about 26000 out of the 100,000 or so recs. The PK doesn't seem to be an FK reference from any other table. I'm hoping that all I'll lose is a few days worth of monitoring data.