Re:TEMP tablespace not Freeing the space
- From: "Alessandro Vercelli" <alever@xxxxxxxxx>
- Date: Thu, 22 Jun 2006 10:26:26 +0200
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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
