Tablespace, Diskspace or sql abuse..

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