Wednesday, November 6, 2013

how to check the corrupted block in oracle?

use the below query to find out block corruption in oracle database
if the block is index try to rebuild or drop/recreate it
if the block is table block reload data using expdp/impdp or db link


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