--启用10231内部事件
ALTER SYSTEM SET EVENTS '10231 trace name context forever,level 10' ;

rename 表名 to 表名 _cor (备份)
create table 表名 nologging parallel 4 as select * from 表名_cor

--关闭10231内部事件
ALTER SYSTEM SET EVENTS '10231 trace name context off';

查找坏块
select * from v$database_block_corruption order by file#;

Select b.segment_name, b.segment_type
from dba_extents a, dba_segments b
where a.file_id =file#名称
and 块号 between a.block_id and a.block_id + a.blocks - 1
and a.segment_name = b.segment_name
and a.owner = b.owner;