Script: database_block_corruption.sql

-- -----------------------------------------------------------------------------------
-- File Name    : https://oracle-base.com/dba/11g/database_block_corruption.sql
-- Author       : Tim Hall
-- Description  : Displays the users who currently have admin privileges.
-- Requirements : Access to the V$ and DBA views.
--                Assumes a RMAN VALIDATE has been run against a datafile, tablespace
--                or the whole database before this query is run.
-- Call Syntax  : @database_block_corruption
-- Last Modified: 29/11/2018
-- -----------------------------------------------------------------------------------

COLUMN owner FORMAT A30
COLUMN segment_name FORMAT A30

SELECT DISTINCT owner, segment_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;