Joe >ORA-00604: error occurred at recursive SQL level 1 >ORA-01578: ORACLE data block corrupted (file # 1, block # 1874) >ORA-01110: data file 1: '/dba02/oradata/orcl/system01.dbf' Just for curiosity... What does the following query returns? SELECT owner, segment_name, segment_type FROM dba_extents WHERE file_id = 1 AND 1874 BETWEEN block_id AND block_id+blocks-1; And, if you have an output, what does an ANALYZE TABLE|CLUSTER|INDEX ... VALIDATE STRUCTURE on that segment return? Regards, Chris -- //www.freelists.org/webpage/oracle-l