Re: strange error ora-00604 01578 01110

What do you mean by iTar ??

Regards

"Daniel Morgan" <dmorgan_at_exesolutions.com> a écrit dans le message news: 3CE5368A.997C060F_at_exesolutions.com...
> 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 Tue May 21 2002 - 02:56:35 CDT