ORA-01578（数据块损坏） 错误解决

执行select b.dataname, count(distinct a.username)
from ics001.user_info a, ics001.data_dict_info b
where feestatus=1 and regflag=1
and a.localarea=b.subclassid
and b.dicttype=102
and registdate>=to_date('2008-10-10 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
and registdate<=to_date('2008-10-16 23:59:59', 'yyyy-mm-dd hh24:mi:ss')
group by b.dataname

报错

ORA-01578: ORACLE 数据块损坏（文件号15，块号55470）
ORA-01110: 数据文件 15…………

解决措施：

 1. 检查损坏的对象

SELECT *
  FROM dba_extents
 where file_id = 15 and 55401 between block_id and block_id+blocks-1