Re: Error Using Oracle by ORDER BY

Mladen Gogala <mgogala_at_earthlink.net> wrote in message news:<pan.2002.01.15.21.54.24.844404.10075_at_earthlink.net>...
> On Tue, 15 Jan 2002 04:50:04 -0500, Amir Pashazadeh wrote:
>
> > Hi,
> >
> > when I write "select * from exam" in SQLPlus, the result will be given,
> > but when I write "select * from exam order by takedate" the following
> > errors will be reported:
> >
> > select * from exam order by takedate
> > *
> > ERROR at line 1:
> > ORA-01114: IO error writing block to file 4 (block # 524250) ORA-27069:
> > skgfdisp: attempt to do I/O beyond the range of the file OSD-04026:
> > Invalid parameter passed. (OS 524250) ORA-01114: IO error writing block
> > to file 4 (block # 524250) ORA-27069: skgfdisp: attempt to do I/O beyond
> > the range of the file OSD-04026: Invalid parameter passed. (OS 524250)
> >
> > why is it so? and how can this be repaired?
> >
> > takedate is a VARCHAR2 field,
> >
> > tanx
>
> You have an old version of oracle (7.x, 8.0.x) which can only access up to
> 2GB files and you have a file which has grown up beyond 2GB. Your file is
> corrupt and if it cannot be repaired. Export everything you can, upgrade
> your oracle and import it back. Be prepared to suffer some data loss.

Hi,
I'm using Oracle 8i R3 (8.1.7) as my database, and the platform is Windows 2000 Advanced Server, but the error still remains...,

well, someone said it should be something wrong with the teporary tablespace, because the error just occures on queries with big result set, using ORDER BY phrase,

I checked the TEMP01.DBF by DBV, and it reported an I/O error while checking the file, what can it be?

tanx,
Amir Received on Thu Jan 17 2002 - 04:36:11 CST