Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Error Using Oracle by ORDER BY

Error Using Oracle by ORDER BY

From: Amir Pashazadeh <pasha_at_abdnet.com>
Date: 15 Jan 2002 01:50:04 -0800
Message-ID: <8f08c432.0201150150.9b934f2@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 - 03:50:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US