Re: Error Using Oracle by ORDER BY

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.

-- 
Mladen Gogala