Re: temp tablespace

From: <kreitsch_at_my-deja.com>
Date: Tue, 19 Sep 2000 15:59:22 GMT
Message-ID: <8q82gc$qd2$1@nnrp1.deja.com>

I think altering the temp-Ts affecting the segmenttype or segmentallocation forces Oracle to free the segments befor changing storage, if you alter maxextents on the temporary ts you will have the same effect.

/Karl

In article <8pb41a$qr$1_at_nnrp1.deja.com>, senthil <rsenthilkumar_at_my-deja.com> wrote:
> Excellent, it worked well now. i changed the database state to
> permanent and waited for few minutes and set back to temporary. it was
> free now. can anyone explain me whats the oracle process/concept runs
> behind this.
> thanks for your help/suggestions.
> -senthil.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 19 2000 - 10:59:22 CDT