Re:TEMP tablespace not Freeing the space

From: Alessandro Vercelli <alever_at_libero.it>
Date: Thu, 22 Jun 2006 10:18:57 +0200
Message-Id: <J195RL$D239712D30CB076FFFE0660A920DF441@libero.it>

Hi Ravi,
just one caveat: the TEMP segment is related not only to TEMP tbs; please, specify your exact error code: ORA-01650,ORA-01652,ORA-01653,ORA-01654,ORA-01688 ?

Regards,

Alessandro

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

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

Received on Thu Jun 22 2006 - 03:18:57 CDT