Re: Tablespace, Diskspace or sql abuse..

Another possibility is that your tempfile is allocated, and your block size is at least 8K, on a system that is not configured for large file support, i.e. files over 2GB in size. Make sure that your system can support large files if the other suggestions fail.

HTH,
Brian

nikey11 wrote:
>
> 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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"