It looks like you have a corrupt (or too large for the os) datafile , file4.
As it only appears in a query with order by I would guess that it is a
datafile in the temp tablespace. In this case you should be able to drop and
recreate the temporary tablespace. If it is in a permanent tablespace, or
your temporary tablespace contains permanent objects you will have to do
recovery. You can discover which file we are talking about by querying
dba_data_files.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Amir Pashazadeh" <pasha_at_abdnet.com> wrote in message
news:8f08c432.0201150150.9b934f2_at_posting.google.com...
> 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
Received on Tue Jan 15 2002 - 04:13:28 CST
