Re: strange error ora-00604 01578 01110

On Fri, 17 May 2002 16:41:30 +0200, "Marc Hoang" <marc.hoang_at_asterop.com> 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
>

You are using the wrong dictionary view. You should check dba_extents.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 17 2002 - 11:49:01 CDT