ORA-01578: ORACLE data block corrupted (file # 16, block # 27059)
SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS
WHERE file_id = 16 AND 27059 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1
查到表或索引,最简单的方法删了重建,也可以恢复。
ORA-01578: ORACLE data block corrupted (file # 16, block # 27059)
SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS
WHERE file_id = 16 AND 27059 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1
查到表或索引,最简单的方法删了重建,也可以恢复。