Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- COLUMN owner FORMAT A20
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement