Re: Temp Tablespace Full

From: HansF <News.Hans_at_telus.net>
Date: Sun, 25 Dec 2005 16:29:15 GMT
Message-ID: <pan.2005.12.25.16.29.12.704202@telus.net>

On Sun, 25 Dec 2005 08:20:30 -0800, Michael42 wrote:

> Hello,
>
> In Oracle 9i I ran an operation that gathered statistics. It ran for
> several hours and I ended up having to break out of it. The result is
> that my TEMP tablespace is full (OEM shows it as full).
> Other than bouncing the database how can I have the TEMP tablespace
> clean itself up?
>

Is this really a problem? Lots-a misunderstanding about temp tbsp - check http://asktom.oracle.com/pls/ask/f?p=4950:8:5441221212647011140::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:374218170986

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Sun Dec 25 2005 - 10:29:15 CST