Oracle Blocchi Corrotti

Lista degli oggetti con blocchi corrotti

SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name, e.bytes/(1024*1024) mb 
 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;