Re: Problem About Temporary Tablespace !!

"Ronny Widjaja" <widjaja31_at_telkom.net> wrote in message news:91e058df.0406101708.2fadfd3_at_posting.google.com...
> When i running my script, i have an error message like this :
>
> ERROR at line 1:
> ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> ORA-27059: skgfrsz: could not reduce file size
> OSD-04005: SetFilePointer() failure, unable to read from file
> O/S-Error: (OS 112) There is not enough space on the disk.
> ORA-06512: at "MUSHROOM.AP_KWAY_JOIN", line 48
> ORA-06512: at line 1
>
> Is there anyone could help me whats problem that i get now ? and how
> to solve this problem ?
> May be i have to free temporary tablespace ? and how to free temporary
> tablespace from my script ?
>
> Thanx And Plz
> Ronny Widjaja

Well, at the risk of stating the obvious, you don't have enough hard disk space in the machine that you're running Oracle on. That's what the 'O/S-Error' line in your error message is telling you.

What machine is this running on? A home one for testing purposes? Or a production system of some kind? If it's a home one, then you could try and find other files on your hard disk to delete. And then you could drop the temporary tablespace and re-create it with much smaller data files. If it's a production system, however, I'd be looking to purchase or utilising more hard disk space.

Regards
HJR Received on Thu Jun 10 2004 - 20:18:13 CDT