Block corruption
I am using Oracle 11.2.0.1 on Windows 2008 . I am getting the block corruption error when I select count() on couple of tables.
SQL> select count(*) from report_details;
select count(*) from report_details
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 92, block # 109987)
ORA-01110: data file 92: 'F:\DATA\DEV\IXREP01_1.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option
select count(*) from comp_temp_items
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 183, block # 167331)
ORA-01110: data file 183: 'F:\DATA\DEV\IXREP01_2.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option
Looks like the corruption occured in index tablespace called (IXREP01)