: error occurred at recursive SQL level 1
: ORACLE data block corrupted (file # 1, block # 1874)
: data file 1: '/dba02/oradata/orcl/system01.dbf'
Just for curiosity... What does the following query returns?
SELECT owner, segment_name, segment_type
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?