Wednesday, November 13, 2013

script to identify the corrupted block name in oracle database?

select segment_name,segment_type,owner
from sys.dba_extents
where file_id=180
and (133571) between block_id and block_id + blocks -1;

No comments:

Post a Comment