Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem About Temporary Tablespace !!

Problem About Temporary Tablespace !!

From: Ronny Widjaja <widjaja31_at_telkom.net>
Date: 10 Jun 2004 18:08:29 -0700
Message-ID: <91e058df.0406101708.2fadfd3@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 Received on Thu Jun 10 2004 - 20:08:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US