ORA-01578 ORACLE data block corrupted (file # string, block # string)
Cause: The data block indicated was corrupted, probably due to program errors.Action: Determine which object was corrupted using a command like the following:SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS
WHERE file = FILE_ID AND block BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;
where values for file and block are from the message. Try to restore the segment containing the block indicated. This may involve dropping the segment and re-creating it. If there is a trace file, report the errors in it to Oracle Support Services.
Cause: The data block indicated was corrupted, probably due to program errors.Action: Determine which object was corrupted using a command like the following:SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS
WHERE file = FILE_ID AND block BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;
where values for file and block are from the message. Try to restore the segment containing the block indicated. This may involve dropping the segment and re-creating it. If there is a trace file, report the errors in it to Oracle Support Services.
Cause: This message reports the file name involved with other messages. Action: See the associated messages for a description of the problem.