Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. COLUMN owner FORMAT A20
  2. COLUMN segment_name FORMAT A30
  3.  
  4. SELECT DISTINCT owner, segment_name
  5. FROM v$database_block_corruption dbc
  6. JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1
  7. ORDER BY 1,2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement