Re: Tablespace, Diskspace or sql abuse..

"nikey11" <member31783_at_dbforums.com> wrote in message news:3037250.1056459712_at_dbforums.com...

> Hi you'll,

I'm not it, but...

> 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.

You're both right. Can you confirm that file 201 is one of the datafiles in temporary tablespace?

> Is this query unacceptable

God only knows. I'd need to see what tables and indexes are being used, what data model, what are you trying to achieve, etc.

Now, is it *efficient*? An EXPLAIN PLAN would help. Versions, OS, etc.

> Posted via http://dbforums.com

How come all of a sudden we get so many posts here from dbforums? Something wrong with its "private" lists? Did this place just get "discovered"?

Andrewst, what's going on? There are more posts here from your forum than inside it...

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam