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;
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