RE: TEMP tablespace not Freeing the space

Db version? Temp tablespace type LOCAL/Dictionary  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ravi Madabhushanam Sent: Wednesday, June 21, 2006 4:43 PM
To: Oracle-L_at_freelists.org
Subject: TEMP tablespace not Freeing the space  

Hi all,

          In our Development system, We have a TEMP tablespace.

          Just now we got the message that "Unable to extend TEMP segment..".

          We have bounced the database to free up this tablespace. But, even then it is not freeing any space.

          Can any one tell me how to go about this with out adding any datafile.  

          Please reply soon.. any help would be greatly appereciated.  

Regards,

Ravi.M

--
http://www.freelists.org/webpage/oracle-l