Re:TEMP tablespace not Freeing the space

Sorry for the mistake: only ORA-1652 is related to temp segment.....but, Ravi can you post the complete error message?

Thanks,

Alessandro

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

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