strange error ora-00604 01578 01110

From: Marc Hoang <marc.hoang_at_asterop.com>
Date: Fri, 17 May 2002 16:41:30 +0200
Message-ID: <ac34ep$rb5$1@reader1.imaginet.fr>

Hello,

When I try to delete an index or a specific table (both located in tablespace data0001), I receive the errors:

ora-00604 error in recursive bloc
ora-01578 block corrupt : file 1 block# 24790
ora-01110 file : c:\......\system01.dbf

The same error occurs when I try to get a list of stored procedures.

When I try to find out whats's going on block# 24790: select *
from dba_segments
where header_file = 1 and header_block > 22380 and header_block < 26004 order by header_block;

OWNER SEGMENT_NAME PARTITION_NAME                 SEGMENT_TYPE
TABLESPACE_NAME
HEADER_FILE HEADER_BLOCK      BYTES     BLOCKS    EXTENTS INITIAL_EXTENT

NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS RELATIVE_FNO BUFFER_
------------ -------

SYS JAVA$CLASS$MD5$TABLE   TABLE              SYSTEM   1        22387
262144         32          3          65536      147456           1
2147483645           50          1               1       1 DEFAULT

AURORA$JIS$UTILITY$   AURORA$IIOP$SYSTEM$PROPERTIES  TABLE    SYSTEM    1
26003     65536          8          1          65536

Sorry for the formatting...

The strange thing is that I have apparently no block assigned in 24790 !!!

Am I missing something?

Platform: Win2k
Oracle 8.1.7 EE

Thank you for your help,

Marc Hoang Received on Fri May 17 2002 - 09:41:30 CDT