ORA-01578 ORACLE data block corrupted
In case this happens, Metalink provides a super-duper statement, that will show you the name and type of the corrupt segment:
SELECT segment_name , segment_type , owner , tablespace_name
FROM sys.dba_extents
WHERE file_id = &bad_file_id
AND &bad_block_id BETWEEN block_id and block_id + blocks -1
To fix it, I used toad to recreate the tables/indexes that were corrupt.
SELECT segment_name , segment_type , owner , tablespace_name
FROM sys.dba_extents
WHERE file_id = &bad_file_id
AND &bad_block_id BETWEEN block_id and block_id + blocks -1
To fix it, I used toad to recreate the tables/indexes that were corrupt.
