Oracle Blocchi Corrotti

SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name from v$database_block_corruption dbc JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1 order by 1,2;