ORA-01578

ORA-01578 ORACLE 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_EXTENTSWHERE file_id = FILE_ID ANDblockBETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;

where values forfileandblockare 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.