Re: Tablespace, Diskspace or sql abuse..

This is a disk issue. Definitely not caused by your query. Have the unix admin check /var/adm/messages. (assuming unix) I bet they will find a disk problem.

"nikey11" <member31783_at_dbforums.com> wrote in message news:3037250.1056459712_at_dbforums.com...
>
> Hi you'll,
>
> I've encounered a problem that recieved the following error:
>
> ORA-01114: IO error writing block to file 201 (block # 359561)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 359567)
> ORA-01114: IO error writing block to file 201 (block # 359561)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 359567)
> ORA-01114: IO error writing block to file 201 (block # 359561)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 359567)
>
> My dba claimes that the problem is caused by a not logical query, I
> think it is a tablespace problem, maybe you can be the judge.
>
> My query joins a table (of 1358453 rows) to itself :
> The comparison fields are a date field and an int field when the date
> field is joined with the ">" operator and the int field is joined by
> equalization,
> The query is again joined to my previous table when the join method is
> that the last table date field is between the first table date field and
> the second table date field.
> Is this query unacceptable
>
> --
> Posted via http://dbforums.com
Received on Tue Jun 24 2003 - 11:22:00 CDT