Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error Using Oracle by ORDER BY
Looks like he wrote the error message. See below - begins with ORA-01114 :-)
"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message
news:3C471132.98FB8CFC_at_exesolutions.com...
> 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 Fri Jan 18 2002 - 21:27:36 CST