Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Error Using Oracle by ORDER BY
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 - 03:50:04 CST
![]() |
![]() |