Re: Error Using Oracle by ORDER BY

I don't know. Have you considered telling us what the error message is? Or do you want us to just guess a lot?

Daniel Morgan

Amir Pashazadeh wrote:

> 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 - 12:00:19 CST