Re: clean up the temp space

From: Patrick Hamou <patrick_hamou_at_hotmail.com>
Date: Fri, 01 Sep 2000 23:08:19 GMT
Message-ID: <DFWr5.223554$1h3.4024530@news20.bellglobal.com>

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 Fri Sep 01 2000 - 18:08:19 CDT