Re: strange error ora-00604 01578 01110

Marc Hoang wrote:

> 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

Only an iTAR. I would get one ASAP.

Daniel Morgan Received on Fri May 17 2002 - 11:57:52 CDT