Re: Oracle 8i IO errors

either the disk is full or you have corrupt blocks. do a "analyze table <table of your index> validate structure cascade;" to check for corrupt blocks. this happens to us all the time ( once a month)

good luck

"Chloe Crowder" <chloe.crowder_at_bl.uk> wrote in message news:<aatjig$5fq$1_at_south.jnrs.ja.net>...
> A problem has reared its head on one of our servers and I need some help.
>
> While loading records at the point when the process tried to create the
> index required before processing starts the following error message was
> received:
>
> SQL EXCEPTION: ORA-00603: ORACLE server session terminated by fatal error
> ORA-01114: IO error writing block to file 4 (block # 524232)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 524232)
> ORA-01115: IO error reading block from file 4 (block # 366740)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 366740)
> ORA-01115: IO error reading block from file 4 (block # 366740)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 366740)
>
> I tried to create the index manually but got the same error minus the first
> line.
>
> The database is running on an NT4 server, with all disks mounted locally,
> i.e. no remote mounts, optical drives etc. Since an index was being created
> I think its probably a temporary area involved, but I can't be certain of
> this.
>
> Any help would be much appreciated, since my knowledge of Oracle could be
> fitted in a small matchbox without taking the matches out first. Ingres, I'm
> your girl, but Oracle I'm still at the floundering stage!
>
> Chloe Crowder
> The British Library
Received on Fri May 03 2002 - 18:57:04 CDT