Re: clean up the temp space

same thing happens in 8.....
You are right in your resolution, (bear in mind you have to set it back to temporary).

Patrick Hamou wrote:

> I had the same error... I had a transaction that occupied 100% of the
> temporary tablespace
> and the temporary tablespace was of type temporary...
> to solve the problem, I changed the type of the temporary tablespace to
> permanent :
> alter tablespace temp permanent;
>
> and 10 seconds later, the temporary tablespace was flushed and went back to
> 0%
> of utilisation...
>
> it seems to be a bug in 7.3.4.4.1 or not far from that version...
>
> regards,
>
> Patrick Hamou
> Oracle Certified DBA
>
> "senthil" <rsenthilkumar_at_my-deja.com> wrote in message
> news:8op26m$cvd$1_at_nnrp1.deja.com...
> > hi,
> > is there any way to clean-up the temp space.
> > any help is appreciated.
> > thanks
> > -senthil
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Sun Sep 03 2000 - 01:31:29 CDT