Re: Should a temporary segment disappear after 125 minutes?

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Thu, 07 Jun 2001 12:27:17 GMT
Message-ID: <3b1f7126.3095964@news-server>

On 6 Jun 2001 13:46:54 -0700, yong321_at_yahoo.com (Yong Huang) wrote:

>
>I know it'll go away if I bounce the database. I also know leaving it
>in TEMP is OK. What I'm doing is only for studying how Oracle works.
>

No need to bounce. If your TEMP tablespace is TEMPORARY, just OFFLINE/ONLINE it with a script. Gotta pick a time when nothing is being used in it. This clears the "hung" segments. This problem been there on and off since V7.1.6, about bloody time it got fixed!!!! <sigh>

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Thu Jun 07 2001 - 07:27:17 CDT