If the corrupted block contains user object, then you are safe.
You can drop that object and recreate in a different tablespace.
Execute following query to finedout which object occupies the
corrupt block.
SELECT SEGMENT_NAME, SEGMENT_TYPE FROM DBA_EXTENTS WHERE FILE_ID = 1 and 14022 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;




Reply With Quote