Hi,
in 10g R2 , I have this in alertlog :
ORA-01578:datablock altered(file # 3, bloc # 30029)
ORA-01110: file 3 : 'D:\BASE\RPRMAN\SYSAUX01.DBF'
Then I try to find the corrupted table :
SQL> SELECT tablespace_name, segment_type, owner, segment_name
2 FROM dba_extents
3 WHERE file_id = 3
4 AND 30029 BETWEEN block_id AND block_id + blocks - 1;
TABLESPACE_NAME SEGMENT_TYPE OWNER
------------------------------ ------------------ ---------------
SEGMENT_NAME
-----------------------------------------------------------------
SYSAUX TABLE SYSMAN
MGMT_SYSTEM_PERFORMANCE_LOG
Then it is MGMT_SYSTEM_PERFORMANCE_LOG table.
But when I query that table :
SQL> select count (*) from sysman.MGMT_SYSTEM_PERFORMANCE_LOG;
COUNT(*)
----------
3342
Is ithe table realy corrupted ?
Thank.